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

[Bastien Koert]

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" <[EMAIL PROTECTED]>
Reply-To: "Arne Essa Madsen" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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;
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php