[germainebull]

I am getting this error message while browsing certain site:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in / .....

What is this error?

[gilggg]

You can try this code:

Code: Select all

<?PHP
$sql = 'some query...';
$result = mysql_query($q);

if (! $result){
   throw new My_Db_Exception('Database error: ' . mysql_error());
}

while($row = mysql_fetch_assoc($result)){
  //handle rows.
}
?>

Note the check on (! $result) -- if your $result is a boolean, it's certainly false, and it means there was a database error, meaning your query was probably bad.

[CyberFreak]

It is a coding error... really those debug/warnings should not be visible to visitors (well it is good practice not to have them visible anyway) but it is nothing you can fix if you don't run the site. Maybe email the site admin(s) to notify them but other than that, ignore it.

[germainebull]

It is a coding error... really those debug/warnings should not be visible to visitors (well it is good practice not to have them visible anyway) but it is nothing you can fix if you don't run the site. Maybe email the site admin(s) to notify them but other than that, ignore it.

Given that I no longer see this error message, I have chosen to ignore it. In any case, I have no coding expertise.

Thanks for your advice.

[thisnthat]

It is a coding error... really those debug/warnings should not be visible to visitors (well it is good practice not to have them visible anyway) but it is nothing you can fix if you don't run the site. Maybe email the site admin(s) to notify them but other than that, ignore it.

I almost didn't recognize you.

Is this true of other errors as well? Is it safe to ignore them or is it better to leave the site if it's jacked up?