Mysql Error

[omesa]

Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it?
mysql_num_rows(): supplied argument is not a valid MySQL result

Regards, omesa

[b225ccc]

You need to pass a valid resource to the mysql_num_rows() function. For instance, you would generally build your query:

$query = "SELECT * FROM tablename";

Then to get the result:

$result  = mysql_query($query);

You can then use the mysql_num_rows() function:

$number_of_rows = mysql_num_rows($result);

If your code looks similar to what I have, check that your query is valid.

Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it?
mysql_num_rows(): supplied argument is not a valid MySQL result

Regards, omesa

[omesa]

Thanks for your replies I will try it out and get back to you.
Regards, Omesa