".$_SESSION["secret_s"]."
".$result; if($result=="TRUE") { // echo "The Result is ".$result;die(); $name=$_POST['name']; $lname=$_POST['lname']; $email=$_POST['email']; $countryids=$_POST['countryids']; $regdate=date('Y-m-d'); $i=","; if ($countryids[0]!=0) { foreach($countryids as $v) $i = $i.$v.","; } else { $i=",0,"; } $sqlsub="select * from subscribers where email='".str_singleQuoteReplace($email)."'"; $qrysub=mysql_query($sqlsub) or die("Error : ".mysql_error()); if (mysql_num_rows($qrysub)==0){ $sqlsub="insert into subscribers(name,lname,email,interest,regdate) values('".str_singleQuoteReplace($name)."','".str_singleQuoteReplace($lname)."','".str_singleQuoteReplace($email)."','".$i."','".$regdate."')"; $qrysub=mysql_query($sqlsub) or die("Error : ".mysql_error()); $tomail="deb@caribbeanlandandproperty.com"; $tomail1="updates@caribbeanlandandproperty.com"; //$tomail2="stewart@caribbeanlandandproperty.com"; //$tomail3="venetta@caribbeanlandandproperty.com"; //$tomail4="mark@caribbeanlandandproperty.com"; $subject="New Subscriber"; $frommail="info@caribbeanlandandproperty.com"; $bouncemail="bounce@caribbeanlandandproperty.com"; $fromname="CLP Subscriber"; $message = "Following are the details of new subscriber :"; $message .= "

Name : ".str_htmlSpecialChars($name); $message .= "
Last Name : ".str_htmlSpecialChars($lname); $message .= "
Email : ".str_htmlSpecialChars($email); $interest=""; if ($countryids[0]!=0) { foreach($countryids as $v){ $sqlcountry="select * from countries where countryid=".$v; $qrycountry=mysql_query($sqlcountry) or die("Error : ".mysql_error()); $rowcountry=mysql_fetch_array($qrycountry); if ($interest=="") $interest = $rowcountry["countryname"]; else $interest = $interest.", ".$rowcountry["countryname"]; } } else { $interest="Any/All Properties"; } $message .= "
Interested In : ".str_htmlSpecialChars($interest); //mail($tomail,$subject,$message,"From: ".$fromname." <".$frommail.">\nReturn-Path:".$bouncemail."\nContent-Type: text/html; charset=iso-8859-1"); //mail($tomail1,$subject,$message,"From: ".$fromname." <".$frommail.">\nReturn-Path:".$bouncemail."\nContent-Type: text/html; charset=iso-8859-1"); require 'phpmm/PHPMailerAutoload.php'; $mail = new PHPMailer; $mail->setFrom('consultant@caribbeanlandandproperty.com', 'CLP'); $mail->Password = '$99HomerCLP'; $mail->Username = 'consultant@caribbeanlandandproperty.com'; $mail->addAddress('deb@caribbeanlandandproperty.com'); $mail->addCC('consultant+subscribe@caribbeanlandandproperty.com'); $mail->Subject = $subject; $mail->Body = $message; $mail->IsHTML(true); $mail->SMTPDebug = 0; if ($mail->send()) { $msuccess="Yes"; } else { $msuccess = "No"; /*echo "Mailer Error: " . $mail->ErrorInfo; */ } //$msuccess="Yes"; } else { $sqlsub="update subscribers set interest='".$i."' where email='".str_singleQuoteReplace($email)."'"; //echo $sqlsub."
"; $qrysub=mysql_query($sqlsub) or die("Error : ".mysql_error()); $tomail="deb@caribbeanlandandproperty.com"; $tomail1="updates@caribbeanlandandproperty.com"; $subject="Subscriber Update"; $frommail="info@caribbeanlandandproperty.com"; $fromname="CLP Subscriber"; $message = "Following are the details of subscriber, who updated his/her countries :"; $message .= "

Name : ".str_htmlSpecialChars($name); $message .= "
Last Name : ".str_htmlSpecialChars($lname); $message .= "
Email : ".str_htmlSpecialChars($email); $interest=""; if ($countryids[0]!=0) { foreach($countryids as $v){ $sqlcountry="select * from countries where countryid=".$v; $qrycountry=mysql_query($sqlcountry) or die("Error : ".mysql_error()); $rowcountry=mysql_fetch_array($qrycountry); if ($interest=="") $interest = $rowcountry["countryname"]; else $interest = $interest.", ".$rowcountry["countryname"]; } } else { $interest="Any/All Properties"; } $message .= "
Interested In : ".str_htmlSpecialChars($interest); //mail($tomail,$subject,$message,"From: ".$fromname." <".$frommail.">\nReturn-Path:".$frommail."\nContent-Type: text/html; charset=iso-8859-1"); //mail($tomail1,$subject,$message,"From: ".$fromname." <".$frommail.">\nReturn-Path:".$frommail."\nContent-Type: text/html; charset=iso-8859-1"); require 'phpmm/PHPMailerAutoload.php'; $mail = new PHPMailer; $mail->setFrom('financial@caribbeanlandandproperty.com', 'CLP'); $mail->addAddress('deb@caribbeanlandandproperty.com'); $mail->addCC('consultant@caribbeanlandandproperty.com'); $mail->Subject = $subject; $mail->Body = $message; $mail->IsHTML(true); $mail->SMTPDebug = 0; if ($mail->send()) { $msuccess="Yes"; } else { $msuccess = "No"; /*echo "Mailer Error: " . $mail->ErrorInfo; */ } //$msuccess="Yes"; } } else { $msuccess="security"; } } include "includes/keywords.php"; ?>
N E W S L E T T E R   &  P R O P E R T Y    U P D A T E S

Thank you for subscribing.

Soon you will start receiving our regular newsletters.


Email already subscibed.


Wrong security code typed. Try again.


toptextcontent; else $content=""; echo $content; ?>

Christian/First Name :