[RESOLVED] mysql_fetch_assoc() error

[OniLink]

Hi, I'm getting the following error, and I don't understand why. Everything is working as it's suppose to, but this error still pops up:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/.../classes/database.php on line 75

I've attached the part of the code that seems to be going wrong.

Any help would be appreciated.

[laserlight]

1. Check the database server connection.
2. Check that a valid database is selected.
3. Check that the SQL statement is correct.

[OniLink]

It's all correct. The intended result occurs... but it still comes up with this error. Could it be because there is another query before this part of the code that also uses the fetch assoc?

[Weedpacket]

Well, you're changing the value of $result while you're still using it in the loop. Perhaps using more informative variable names would help avoid the risk of trying to use the same one for two different things at the same time.

[OniLink]

Thats it! Thanks heaps. Definitely a stupid oversight.