mysql_num_rows problem

Nixon

Hey all,

I have the following piece of code on my site:

$getinfo=mysql_query("select * from memberinfo where username='$seusername' and password='$sepassword'");
$count=mysql_num_rows($getinfo);

When I run it however it throws up a mysql_num_rows error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/swimming/public_html/guitar/includes/enterdetails.php on line 26

The code above is line 26.

Any ideas?

Thanks. Jack

yelvington

The manual includes helpful examples of how to call mysql_error() in the event of a failed query.

http://www.php.net/mysql_query

sidney

are $seusername and $sepassword set try echoing them beore query to check there value

laserlight

If $seusername or $sepassword are not set, PHP should report a notice.
MySQL should not report an error.

Rather, check your database connection and selection.
Another possibility would be that your query's SQL is wrong.
As yelvington mentioned, you can debug by using:

$getinfo = mysql_query("SELECT * FROM `memberinfo` where `username`='{$seusername}' AND `password`='{$sepassword}'")
	OR die(mysql_error()); //for debugging

Nixon

Yeah I sorted it now thanks for the replies.