RE: Problems with mysql_num-rows()

["Bastien Koert" <bastien_k@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxx>
> Reply-To: "Arne Essa Madsen" <arne@xxxxxxxxxxxxxxxxxx>
> To: php-db@xxxxxxxxxxxxx
> Subject:  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@xxxxxxxxxxxxxxxxxx
>
> --
> 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