i have tried to remove the @ which looks like this now $cx = mysql_connect('localhost', 'db', 'password'); mysql_select_db("db") or die( "Unable to select database"); and also used without MYSQL_ASSOC, but still im getting the same error message. Can anyone help me please --- Ryan Sexton <rsexton@xxxxxxxxxx> wrote: > Are you sure the Conn_to_Mysql.php contains the > correct username and > password and the correct host to where your mysql > installation is? I'd > say you're failing to make a connection to your > mysql database at the > office because it's setup differently. I'd bet you > have a @ in front of > your mysql_connect() statement in that include file. > remove it and run > your script to see what the error message is. > > Good luck, > Ryan > > On Mar 7, 2005, at 6:42 PM, Anuradika wrote: > > > > Hi there, > I have coded the project using php 5.0.3, with MySQL > 4.1. I am using > > require("Conn_to_Mysql.php"); > $query = "Select * from tbl_BBY "; > $result = mysql_query($query); > while($row = mysql_fetch_array($result, > MYSQL_ASSOC)) > { > > } > > Its running in my office pc, and my home pc, but > when i upload to the > webserver, its giving error as such, anyone able to > help me to solve > this issue. > > Warning: mysql_fetch_array(): supplied argument is > not a valid MySQL > result resource > > Thanks in advance. > > ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/