";
include("dbConnect.php"); // connect to DB
// submit button hit
if($_POST[unsubscribe] == "update") {
$email = $_POST[email];
$res = mysql_query("select id from newsletter") or die(mysql_error());
$id = mysql_num_rows($res);// num rows in DB already
// adds email to DB
mysql_query("DELETE FROM newsletter WHERE email='$email'") or die(mysql_error());
//mysql_query(\"insert into email_log (date, emails) values ('$date_formatted', '1')\");
echo "You've successfully unsubscribed from amydiggins.com";
// Send Master List to Amy
$masterList = "";
$emails = mysql_query("SELECT email FROM newsletter");
while($emailArr = mysql_fetch_array($emails)) {
$email = $emailArr['email'];
$masterList = $masterList . $email . ",";
}
mail('aemyers@gmail.com', 'Someone unsubscribed from amydiggins. Heres the new master list', $masterList);
}
else // submit button not hit yet
{
echo "
|
![\"](\"images/amy_diggins.jpg\")
![\"](\"images/caption.jpg\")
![\"](\"images/blank.gif\"){kind=spacer}
![\"](\"images/header.jpg\")
![\"](\"images/nav_top.jpg\")
![\"facebook\"](\"images/facebook.jpg\")
![\"twitter\"](\"images/twitter.jpg\")
![\"](\"images/nav_bot.jpg\")