your information and press "Subscribe"
(financial advisors and insurance agents who desire to send this newsletter to their clients and prospects, click here).'; $msg_class = 'blk2b'; //Form posted back? if(count($_POST)) { extract($_POST); if(md5(strtolower(trim($security_answer))) == $_SESSION['sess_captcha']) { //Reset the captcha from session - this will keep spambots trying for ever $_SESSION['sess_captcha'] = md5(uniqid(rand(), true)); //Check for email duplicacy $query = "SELECT * FROM prospects WHERE email = '$email'"; $res = mysqli_query($conn, $query); if(mysqli_num_rows($res) == 0) { //Insert into prospects table [ DATABASE: advisor_newsletter_jav ] $query = "INSERT INTO prospects SET"; $query.= " first_name = '$first_name'"; $query.= ", last_name = '$last_name'"; $query.= ", email = '$email'"; $query.= ", zipcode = '$zipcode'"; $query.= ", interests = '".implode(", ", $interests)."'"; $query.= ", date_added = NOW()"; mysqli_query($conn, $query); //Empty the values $first_name = $last_name = $email = $confirm_email = $zipcode = ""; $interests = array(); //blank out //Show message // below 2 lines added by Ashish on 15-Mar-2017 header('Location: thankyou.php'); die(); $msg = 'Thank you for subscribing to the SeniorFinances email newsletter.
You will receive the next issue on the 3rd of the month.'; $msg_class = 'grn2b'; } else { $msg_class = 'red2b'; $msg = "This email address is already subscribed"; } } else { $msg_class = 'red2b'; $msg = "Sorry! You typed a wrong verification code! Please try again."; } } ?>


Every month you’ll get a free issue of the retirement newsletter with timely topics covering a broad range of senior retirement financial issues specific to those concerned with preserving and growing their assets in retirement.

See sample retirement newsletter: Click Here

First Name: