Check if value exist in mysql

[zubat]

PHP Code:

$sql = mysql_query("SELECT email FROM users WHERE email ='$email'");
                                    
if(mysql_num_rows($sql) != 0)
{
echo '<font color="ff0000"><li> Email exist!</font>';
} 


So my problem is, that even if i write an email that i know exist in the database it let me through. I got the config.php include a bit up in the code so the database connection is no problem.

//Zubat

[AndrewGSW]

mysql_num_rows returns the number of rows or false. The docs. So you should test against > 0.

NB
The mysql library is deprecated - there is a stark warning against its use on the docs page - and will be removed in the future.
The font tag is obsolete.
Your LI tag is not closed properly, so your HTML is mal-formed.

[TFlan]

A better way:

PHP Code:

is_resource($q); 


$q being the results from the query