Our server just went down for 2 days and now that it is up none of our scripts work any more. We keep getting an error message that looks like this:
Warning: Supplied argument is not a valid MySQL result resource in /www/htdocs/script.php on line 31
On line 31 there is a php MySQL call like this:
$result = mysql_db_query($dbname, $str_sql, $id_link);
$num = mysql_num_rows($result);
After testing the script I noticed that the mysql_num_rows function was not working. Also the mysql_fetch_object(); function doesn't work with conjunction with $result.
If anyone has any ideas why this would be happening please let me know. We have not made any changes to our script since the crash and now it doesn't work. However, our perl scripts work fine.
Thanks,
Brian
Warning: Supplied argument is not a valid MySQL result resource in /www/htdocs/script.php on line 31
On line 31 there is a php MySQL call like this:
$result = mysql_db_query($dbname, $str_sql, $id_link);
$num = mysql_num_rows($result);
After testing the script I noticed that the mysql_num_rows function was not working. Also the mysql_fetch_object(); function doesn't work with conjunction with $result.
If anyone has any ideas why this would be happening please let me know. We have not made any changes to our script since the crash and now it doesn't work. However, our perl scripts work fine.
Thanks,
Brian