PHP error

[david4u]

I am building an aunction site but have an error on this line. The error is

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\AUNCTIOIN\index.php on line 304

And like 304 is

$num_auction = mysql_num_rows($result);

So, what is my error there. I do not see any problem with that.

Can anyone help.

Thanks

[Houdini]

Showing the code prior to the error might help, this is just where the error shows up, not necessarily where the real problems is.

[Weedpacket]

The error message is saying that $result is not a valid MySQL result resource. So obviously there is something wrong about how $result is getting set.

[bradgrafelman]

Look at this post for more information about MySQL debugging.

[david4u]

Thanks for your help.

I have seen where the problem is. the $db needs to be be global.....

Thanks.

[bradgrafelman]

Don't forget to mark this thread resolved!