Unsubscribe E-ChannelNews

Your unsubscribe request was already recorded on $row[unsub_date]"; $sql = "update ecn_unsubscribe set unsub_ecn = '$unsub_ecn', unsub_va = '$unsub_va', unsub_other = '$unsub_other', unsub_date = CURDATE() where unsub_email = '$unsub_email' limit 1"; $result = mysql_query($sql) or die(mysql_error()); echo "

Your unsubscribe record has been updated

"; echo "

Return to Home Page

"; } else { //ok, doesn't exist, now let's enter it. $sql = "insert into ecn_unsubscribe (`unsub_email`, `unsub_name`, `unsub_ecn`, `unsub_va`, `unsub_all`, `unsub_other`, `unsub_date`, `unsub_status`) values ('$_GET[ref]', '$_POST[unsub_name]', '$_POST[unsub_ecn]', '$_POST[unsub_va]', '$_POST[unsub_all]', '$_POST[unsub_other]', CURDATE(), '$_POST[unsub_status]')"; if ($result = mysql_query($sql)) { echo "

Your Unsubscribe request has been recorded.

"; echo "

Return to Home Page

"; //now, let's delete the subscription $sql = "delete from ecn_subscribers where sub_email = '$_GET[ref]' limit 1"; $result = mysql_query($sql) or die(mysql_error()); echo "

Your name has been removed

"; } } } else { if ($_POST['form_submitted'] == "TRUE") { extract($_POST); //need to fix enter the record //first see if this email address exists... include("scripts/connectdb.php"); $sql = "select * from ecn_unsubscribe where `unsub_email` = '$_POST[unsub_email]' limit 1"; $result = mysql_query($sql); if ($row = mysql_fetch_assoc($result)) { echo "

Your unsubscribe request was already recorded on $row[unsub_date]

"; $sql = "update ecn_unsubscribe set unsub_ecn = '$unsub_ecn', unsub_va = '$unsub_va', unsub_other = '$unsub_other', unsub_date = CURDATE() where unsub_email = '$unsub_email' limit 1"; $result = mysql_query($sql) or die(mysql_error()); echo "

Your unsubscribe record has been updated

"; echo "

Return to Home Page

"; } else { //ok, doesn't exist, now let's enter it. $sql = "insert into ecn_unsubscribe (`unsub_email`, `unsub_name`, `unsub_ecn`, `unsub_va`, `unsub_all`, `unsub_other`, `unsub_date`, `unsub_status`) values ('$_POST[unsub_email]', '$_POST[unsub_name]', '$_POST[unsub_ecn]', '$_POST[unsub_va]', '$_POST[unsub_all]', '$_POST[unsub_other]', CURDATE(), '$_POST[unsub_status]')"; if ($result = mysql_query($sql)) { echo "

Your Unsubscribe request has been recorded.

"; echo "

Return to Home Page

"; //now, let's delete the subscription if ($_POST['unsub_all'] == "Y") { $sql = "delete from ecn_subscribers where sub_email = '$_POST[unsub_email]' limit 1"; $result = mysql_query($sql) or die(mysql_error()); echo "

Your name has been removed

"; } } else { //oops, got an error... echo "

Your Unsubscribe request was unsuccessful for the following reason: " . mysql_error() . "

"; } } //now that the request is recorded, let's see if they're actually here. $sql = "select * from ecn_subscribers where sub_email = '$unsub_email' limit 1"; $result = mysql_query($sql); if ($row = mysql_fetch_assoc($result)) { //found it, now let's tell them... echo "

√ Found $unsub_email. Removed.

"; } else { echo "

× $unsub_email not found in our database.

"; } } else { ?>

Name:

e-mail address:

Remove me from

E-ChannelNews
This is the delivery list for e-channelnews information broadcast featuring news, marketing tips, e-business, distributor news, promotions, events, industry stats and more for the computer channel. No other broadcasts are sent to this list.
Vendor Announce
Many Vendors use this list to broadcast their channel-specific news and promotions. This is used to distribute our vendor emmercials (many of which can be customized by resellers). As such, you may not want to unsubscribe from this list as it will block ALL vendor announcements and emmercials.

Unsubscribe me only from the following vendor broadcasts:
E-ChannelNews develops and maintains email lists for many computer vendors to broadcast their exclusive channel-specific information. You can use the space below to remove your name from any specific manufacturers for which you do not wish to receive any information.

All Lists

If you would like to receive newsletters that are specific to your interests and/or from vendors that you want, please click here to subscribe.

 

If you have any further difficulties, please email feedback@e-channelnews.com and indicate the email address you wish to have removed.