Code: Select all
if (strlen($_POST['sponsor_email']) <= 50 && validate_email($_POST['student_email']))
{
// Do not allow duplicate emails
$sponsor_email = $_POST['sponsor_email'];
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$double2 = "SELECT sponsor_email
FROM sponsor
WHERE sponsor_email = '$sponsor_email'";
$find2 = mysql_query($double2);
if ($find2 && mysql_num_rows($find2) > 0)
{echo '<p><h3>Email address already exists in our database.</h3></p>
<a href="sponsor.htm"><strong>Click Here: Return To Form</strong></a>';
}