[Moved to new server, now get MySQL error]

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

[Moved to new server, now get MySQL error]

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.