mjrose2003

Actually, it\'s not the pw. But, since I didn\'t post the domain name...

I used this setup on another server and it worked OK. Now I am forced to move to a new server and the same code returns the error \"Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/homes/public_html/browse.php3 on line 79\" Note - line 79 is >> while ($myrow = mysql_fetch_row($result)) { Here is the code: <?php $db = mysql_connect(\"localhost\", \"homes_Mike\", \"MySQL\"); mysql_select_db(\"homes_homes\",$db); $result = mysql_query(\"SELECT * FROM items2 ORDER BY Price ASC\",$db); echo \"<center><table CELLPADDING=5 border=2 BORDERCOLOR=\'#000099\'> n\"; while ($myrow = mysql_fetch_row($result)) { printf(\"<tr><td><font size=-1>%s</font></td><td><font size=-1>%s</font></td><td><font size=-1>%s</font></td><td><center><font size=-1>%s</font></center></td><td><center><font size=-1>%s</center></td><td><font size=-1>$%s</font></td><td><center><b><font size=-1>%s</font></b></center></td><td><center><font size=-1>%s</font></center></td></tr>n\", $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7]); } echo \"</table></center>n\"; ?> Any suggestions? I\'m in a bind to get this back up.