Project Detail

Description

I need this script to check for duplicate emails. This is a very simple script that is part of a larger script that allows someone to sign up for a newsletter. Just need to check to see if the email address they are inputing is already in database. If it is, print message like "Sorry, email is already in our list".

Will pay $25 right away to someone that can do this immediately.

Here is the code:

if ($type=="SIGNUP")
{
global $page,$email_address,$email_name;

if (isset($email_address))
{
$pos=strpos (strtoupper($email_address), '@');
$pos2=strpos (strtoupper($email_address), '.');
if ($pos===false || $pos2===false)
{
$ret="The email address is not valid!<BR>";
$ret="<form>$content1<input type=hidden name=page value=$page>Your Email : <input type=text name=email_address></><br>";
$ret.="Your name : <input type=text name=email_name value='$email_name'><br><input type=submit value='Sign Up'><br>$content2</form>";
}
else
{
$ret="Thank you for signing up!";
$sql="INSERT INTO sb_email (email,email_name) VALUES('$email_address','$email_name')";
$result=$db->query($sql);
// ADD email in database

}
}else
{
$ret="<form>$content1<input type=hidden name=page value=$page>Your Email : <input type=text name=email_address></><br>";
$ret.="Your name : <input type=text name=email_name value='$email_name'><br><input type=submit value='Sign Up'><br>$content2</form>";
}

}