help with checking if emal...

[fearfx]

Hi guys,

I need help with this.

When a user register's I need to see if the $_POST['email'] is already taken in the MySQL DB. Now Im not what my query and following if statement would look like to achieve if email exists inside the Database then $error = "Email taken"

	  $result = mysql_query("SELECT username,email FROM `wsd_members` WHERE email = '{$_POST['email']}' ");
	  $user = mysql_fetch_array( $result );

if ($user['email'] = $_POST['email'])
  	{
		$error = 'Email is already in use.';
	}

Thanks for the help guys...

[rsmith]

Why query with the username if this is for new registrations. I would do this:

$email = mysql_real_escape_string($_POST['email']) \\this prevents sql injection

$query = "SELECT * FROM `wsd_members` WHERE `email` = '".$email."'";
$result = mysql_query($query);

if($result){
     echo "Sorry, that e-mail has already been used to register.";
     exit(); //or whatever else you do if the e-mail is in use.
}else{
     //finish your script
}