Sign up for the Sportspool Newsletter

SportsPool.com: Newsletter Sign Up

Get the Sportspool Newsletter and start receiving sports updates, recaps, news, and more.

The Sportspool Newsletter gives you all the latest sportspool information, stats on games and players, weekly recaps of the games, as well as providing you information on your pools, if the weekly closure times change, for example, you'll be the first to know. Stay informed with Sportspool.com!

*
*
(* is required)
UNABLE TO COMPLETE SIGNUP.

Sorry, you must enter your email address, please go back and try again.
"; $continue = "no"; } if (($first_name == "") && ($continue == "yes")) { echo "UNABLE TO COMPLETE SIGNUP.

Sorry, you must enter your first name, please go back and try again.
"; $continue = "no"; } if (($userSecurityCode == "") && ($continue == "yes")) { echo "UNABLE TO COMPLETE SIGNUP.

Sorry, you must enter the security validation number (this is to prevent automated scripts from signing up), please go back and try again.
"; $continue = "no"; } //check email is valid if ((filter_var($email_address, FILTER_VALIDATE_EMAIL) == FALSE) && ($continue == "yes")) { echo "UNABLE TO COMPLETE SIGNUP.

Sorry, your email address appears to have an incorrect format, please go back and try again.
"; $continue = "no"; } //check email has no account tied to it $query = "select firstname from newsletter where email = '$email_address'"; $query2 = mysql_query($query) or die(mysql_error()); $query3 = mysql_fetch_array($query2); $emailcheck = $query3[firstname]; if (($emailcheck) && ($continue == "yes")) { echo "UNABLE TO CONTINUE SIGNUP.

Sorry, that email address has already been added to the newsletter.
"; $continue = "no"; } //checks if verification code is right if (($_POST['userSecurityCode'] != base64_decode($_POST['SecurityCode'])) && ($continue == "yes")) { echo "UNABLE TO COMPLETE SIGNUP.

Sorry, the verification number appears to be incorrect, please go back and try again.
"; $continue = "no"; } if ($continue == "yes") { //add to database, but with double optin set as no $query = "insert into newsletter (email, firstname, lastname, double_optin) values ('$email_address','$first_name','$last_name','No');"; $query2 = mysql_query($query) or die(mysql_error()); echo "Success! Your have almost completed signing up for our Newsletter.

We have sent you a confirmation email, just click the link in the email and you are all done.

Thank you for signing up!

~The Sportspool Team"; //send them a message and a link to confirm the signup $message =" Sportspool.com Newsletter Signup"; $message .=""; $message .=""; $message .="

Thank you for signing up to our newsletter!
"; $message .="The only step that remains is to click the final confirmation link below.

"; $message .="Please Click here to finish signing up to the Sportspool.com Newsletter

"; $message .="
"; $message .="-The Sportspool.com Staff"; $emailheaders = "MIME-Version: 1.0\r\n"; $emailheaders .= "Content-type: text/html; charset=iso-8859-1\r\n"; $emailheaders .="From: staff@sportspool.com\r\nReply-To: staff@sportspool.com\r\n"; mail ("$email_address","Thank you for signing up to the Sportspool.com Newsletter",$message, $emailheaders); } //end of if continue is yes } //end of submit clicked if ($confirmed) { $query = "update newsletter set double_optin = 'Yes' where email = '$confirmed'"; $query2 = mysql_query($query) or die(mysql_error()); echo "All done! You are now signed up for our Newsletter.

Thank you for signing up and we hope to entertain you for years to come.

~The Sportspool Team"; } //end of if confirmed by email link ?>