loop through records to check if email exists

$email = $_POST['email'];
   $query_Recordset1 = "SELECT customeremail FROM customers";
   $Recordset1 = mysql_query($query_Recordset1, $evs) or die(mysql_error());
   while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)){;
   $totalRows_Recordset1 = mysql_num_rows($Recordset1);
   if ( $email == $row_Recordset1['customeremail'] ) {
	echo "That email exists";
} else {
	echo "That email doesn't exist";
}
   }

Select all Open in new window