Problem with mysql v4.0 & php v4.3

[sipb2002]

Is this method of accessing a mysql database still supported by php version 4.3 and mysql v4.0? Ive recently been asked to re-host a system I built last summer for another company and I keep getting the following error for the code below:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Any suggestions fo a work around would be really helpful as I havent done any php since the summer 🙁 🙁 damb you ASP!!

<?                 

	$range_info = mysql_query("SELECT * FROM $db_name.range ORDER BY rangename");

  	if (mysql_num_rows($range_info) > 0)
{
   	while($info = mysql_fetch_array($range_info))
{
	$rangename = $info['rangename'];
$rangeid = $info['rangeid'];
$rangestatus = $info['rangestatus'];
if($rangestatus=="0") { $rangestatus="Off"; }
if($rangestatus=="1") { $rangestatus="On"; }

echo"<tr>\n<td id=twobar colspan=3></td>\n</tr>\n";
    echo"<tr>\n<td align=center width=100>\n$rangeid</td>\n";
    echo"<td align=center width=200>\n$rangename</td>\n";
echo"<td align=center width=50>\n$rangestatus</td>\n</tr>\n";
    echo"<tr>\n<td id=twobar colspan=3></td>\n</tr>\n";
    echo"<tr>\n<td id=onebar colspan=3></td>\n</tr>\n";
}
}
?>                          

[devinemke]

$range_info = mysql_query('SELECT * FROM ' . $db_name . '.range ORDER BY rangename') or exit(mysql_error());

[sipb2002]

I tried it and it pointed out to me that my user wasn't assigned rights to the database, but now ive done that and tried it the old scripts work. 😃

Cheers for the quick response.