RE: [PHP-DB] Problems with mysql_num-rows()

Very simply, either your connection is messed up, you are not getting a result set back or there is an error in your sql try this: $result = mysql_query($query, $link) or die ("failed because ".mysql_error()); then start debugging bastien

From: "Arne Essa Madsen" <arne@aem-engineering.dk> Reply-To: "Arne Essa Madsen" <arne@aem-engineering.dk> To: php-db@lists.php.net Subject: [PHP-DB] Problems with mysql_num-rows() Date: Sun, 31 Oct 2004 19:32:09 +0100 I have the following problem: This one does not work: $query = "SELECT * from user where name='$userid' and pass=password('$password')"; $result = mysql_query($query, $link); $num_rows = mysql_num_rows($result); I get this error message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\wamp\www\fs1812_new\authmain.php on line 18 This one works OK: $query = "SELECT * FROM user"; $result = mysql_query($query, $link); $num_rows = mysql_num_rows($result); What is wrong and how can I use mysql_num_rows when the query include "WHERE" A fast response will be very much appreciated. Arne Essa Madsen; arne@aem-engineering.dk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php