[SOLVED] Email Check

[Daney11]

Hey guys,

 

$query = "SELECT member_email FROM members WHERE member_email='$member_email'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {

}

 

Im using this to check wether or not the email address is already been taken, however it isnt working. My form is submitting even with the same email address being used. Any ideas?

 

Thanks

 

[Wes1890]

Are you defining $member_email from $_POST['member_email'] ?

[revraz]

Looks good as long as your variable is right.

 

Here is a function I use

 

function checkUnique($field, $compared)
{
	$query = mysql_query ( "SELECT `" . mysql_real_escape_string ( $field ) . "` FROM `users` WHERE `" . mysql_real_escape_string ( $field ) . "` = '" . mysql_real_escape_string ( $compared ) . "'" );
	if ( mysql_num_rows ( $query ) == 0 )
	{
		return TRUE;
	}
	else {
		return FALSE;
	}
}

[Daney11]

<input name="member_email" type="text"  value="<?php if (isset($_POST['member_email'])) echo $_POST['member_email']; ?>"/>