Page 1 of 1

Simple Question

PostPosted: 24. March 2005 10:33
by GuitarNerd
just wondering how to tell if a query return from mysql is null for example if a user tries to login and enters a name that doesnt exist:

Code: Select all
$query = "SELECT * FROM user_table WHERE user = '$name'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
         
         if ($result == ??????){
         echo "This user does not exist");
         }


how do i check for no return?

Thanks[/code]

Re: Simple Question

PostPosted: 24. March 2005 16:02
by boppy
Hi Eric,

try that:
Code: Select all
$query = "SELECT * FROM user_table WHERE user = '$name'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
         
if (mysql_num_rows($result)==0){
   echo("This user does not exist");
}

PostPosted: 24. March 2005 16:26
by GuitarNerd
thanks so much works like a charm