We have mysql fetch error in many of our hosted sites.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/user/www/xxxx
Where is issue and how can resolve this issue?
That's not really enough information to go on, I'm afraid.
As per the PHP documentation, mysql_fetch_row needs to be provided with a $resource. This usually comes from mysql_query and contains the results from this query. It is very likely that this query failed for some reason, e.g. the database was not connected.
I advise you perform error checking on the commands leading up to this, e.g.
$resource = mysql_connect(...) or mysql_query(...)
Hope this helps.
Last edited by gigatux; 08-18-2009 at 09:07 AM.
Reason: Corrected code