mysql_fetch_assoc()

Awestruck

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\forum\new_index.php on line 60

What should the parameters be? On other forums I get the answer "A resource of course", but what the heck is a resource? Please could someone explain in simple English. The actual code on line 60 that I am using is:
while($row = mysql_fetch_assoc($result))

Weedpacket

When a call to something like [man]mysql_query[/man] fails because of some error, it returns [font=monospace]false[/font] instead of a set of results (the resource). [man]mysql_fetch_assoc[/man] can't get anything out of [font=monospace]false[/font]. [man]mysql_error[/man] can be used to find out what the error was.

See those pages for details.

bradgrafelman

Also, to answer the question "what the heck is a resource," see this manual page: [man]language.types.resource[/man].

EDIT: Equally as important as understanding what a resource is: Stop Using the MySQL Extension!

Awestruck

Many thanks folks
I think I now understand thanks to you. The

resource

is the previous

result

of a query. If that previous query fails, the result is False which is a boolean. Now I know that Line 60 was not where the real error ocurred, it was somewhere earlier in the script. I now have to hunt through the previous 59 lines.