About www.gifts-presents-cards-online.co.uk |
|
|
|
|
Subscribe to the Gifts, Presents & Cards Online newsletter
Stay up to date with the latest gifts and presents to hit the market as well as receiving fantastic offers from some of the leading suppliers. Thank you for subscribing! Information entered successfully.\n"; } else { echo " You're already subscribed. \n";
}
}
else if ($_POST['unsubscribe']) {
$db = mysql_connect("localhost", "graham", "pres280598")
or die ("Couldn't connect.");
mysql_select_db("presents",$db) or die ("Couldn't select db.");
// check the user is already subscribed
$check = "select email from mailList where email = '".$_POST['unsub']."'";
$checkResult = mysql_query($check) or die ("Can't check email address.");
$checkNum = mysql_num_rows($checkResult);
if ($checkNum == 0) {
// a value of 0 implies no resut was found so email was never subscribed
echo "Couldn't find your email address in the database. \n";
} else {
$sql = "delete from mailList where email = '".$_POST['unsub']."'";
@mysql_query($sql) or die ("Couldnt delete email address");
echo "You have successfully unsubscribed. \n";
}
}
else{
// display form
?>
|
|
|||||||||||||
|
Bookmark this page for next time 
|