SnowSeekers Newsletter Confirmation

SnowSeekers Newsletter Confirmation

 

Oops! It looks like you found a page that shouldn't be visible. Please return to the front page and take a look at one of our other stories!'; } else { # Sanatize Email $clean_email = filter_var($email,FILTER_SANITIZE_EMAIL); if ($email == $clean_email && filter_var($email,FILTER_VALIDATE_EMAIL)){ # Database and table to use $database = 'contest_snowseekers'; $table = 'mailchimp_2014-May'; $query = db_fetch_array(db_query("SELECT COUNT(*) FROM $database.`$table` WHERE `Email Address`='{$email}'")); if ($query['COUNT(*)'] > 0){ // print '

Email found: ' . $email . '

'; print '

Thank you, your consent for the SnowSeekers newsletter has been confirmed and you will continue to receive all the latest information about Western Canada's ski resorts, contest officers, and snow conditions all winter long.

'; $sql = "UPDATE $database.`$table`SET confirm = '1' WHERE `Email Address`='{$email}';"; $result = db_query($sql); dpm($result); } else { print '

Email not found: ' . $email . '

'; print '

 

'; print '

If you have recently subscribed to our newsletter and believe this to be in error, please contact nancy@seekers-media.com

'; } } else { print '

Invalid email detected. If you received this message after clicking the I Confirm button from the newsletter, please contact nancy@seekers-media.com.

'; } } ?>