mysql_num_rows
| From: | Luke Kearney | Date: | Sat, 13 Apr 2002 09:00:33 +0000 |
| Subject: | mysql_num_rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18473@lists.php.net to get a copy of this message | ||
Hello All,
I am struggling to understand why my query throws an error the code as below
$link = mysql_connect ( "db.localhost.org", $user , $pass );
if ( ! $link )
die ( "Couldn't Connect to Mysql Server" );
print "Sucessfully connect to server <p>";
$query = "select * from users "
."where screen_name='$screen_name' "
." and passwd=password('$passwd')";
$result = mysql_query($query, $link);
if (mysql_num_rows($result) >0 )
When executed you get a little message back like this one
Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/share/doc/apache/trial/authmain.php on line 20
What does this generally mean as I have noted that others use this syntax so
what is my issue ?
Any help or pointers to references would be most appreciated.
Thanks
Luke K