Problems with mysql_num-rows()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux