I suppose it's nothing to do with the spelling mistake in the sql statement (slecet should be select)
Mark -----Original Message----- From: empty [mailto:[EMAIL PROTECTED]] Sent: 21 November 2002 15:57 To: [EMAIL PROTECTED] Subject: [PHP] mysql_num_rows Hi guys; I have a problem (or mistake(s)); for this code 39| $result=mysql_query("slecet * from site_members where User_Name='$username'"); 40| $num_row=mysql_num_rows($result); 41| if($num_row>0) echo("error 46"); as a reult I have unsolved error in my hands :( Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\sites\inc\register.inc on line 40 NOTE: all the fields on the db are empty anybody knows why? (PHP 4.2.3 SAPI - MySql 3.23.53 - IIS 5.0 running on WinXP) thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php