"".$_POST['firstName']."", "rp-2-Please enter your last name" => "".$_POST['lastName']."","p-4-Please enter valid email-ID" => "".$_POST['email'].""), $validation_ans_arr);
if($_POST[rate]=="" && $_POST[news]==""){
$form_check_alert.="
Please select atleast one newsletter subscription
";
}
if(!strlen($form_check_alert)>0){
checkHTTPREFERER();
$sql=mysql_query("select * from newsletter_member where email='$email' and status!='D'");
$sql2=mysql_query("select * from newsletter_member where email='$email' and status='N'");
if(mysql_num_rows($sql)==0){
mysql_query("insert into newsletter_member set name='$name',email='$email',join_date=now(),status='Y',news='$news',rate='$rate'");
$eID=mysql_insert_id();
}elseif(mysql_num_rows($sql2)>0){
mysql_query("update newsletter_member set name='$name',join_date=now(),status='Y',news='$news',rate='$rate' where email='$email'");
}
$_SESSION['message']=" *** Your have successfully subscribe our newsletter. ";
header("Location: ".SITE_WS_PATH."/rate-watch-signup.htm");
exit;
}
if($form_check_alert!=""){
$msg=html_head();
$msg.=$form_check_alert;
$msg.=html_foot();
}
}
echo mainHeader("Rate Watch Sign-Up");
?>