Troubleshooting "mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource"

Question

Possible Duplicate:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
php warning mysql_fetch_assoc

I am using PHP with a MySQL backend. When I try to connect to the database I am getting the following error.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/htdocs/somefile.php on line 18

Any ideas as to what is wrong?

No one can help you unless you post the actual code that is causing the problem. — John Watson, Nov 22 '11 at 00:20

score 0 · Answer 1 · answered Nov 21 '11 at 18:56

You probably just need a proper MySQL connection, check your database settings make sure the database and tables exist. Posting the code could be helpful if your are still stuck, especially the mysql_connect() part or whatever function calls you are using to connect.

Troubleshooting "mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource"

1 Answers1