';
$error="1";
}
$sql1="select email_address from survey_corporate_customer where email_address='".$_POST[email_address]."'";
$res=mysql_query($sql1) or die(mysql_error());
$num=mysql_num_rows($res);
if($num>0){
$er.="Email Id already exist
";
$error="1";
}
if(!$error){
$sql=" insert into survey_corporate_customer set contact_name='$contact_name',company_name='$company_name',email_address='$email_address',job_position='$job_position',s1='$s1',s2='$s2',s3='$s3',s3_other='$s3_other',s4='$s4',a1='$a1',a2='$a2',a3a='$a3a',a3b='$a3b',a4='$a4',a5='$a5',a6='$a6',a7='$a7',a81='$a81', a82='$a82', a83='$a83', a84='$a84', a85='$a85',a86='$a86',a87='$a87',b11='$b11',b12='$b12',b13='$b13',b14='$b14',b15='$b15',b_2='$b_2',b2_other='$b22other',b_3='$b_3',b41='$b41',b42='$b42',b43='$b43',b44='$b44',b45='$b45',b46='$b46',b47='$b47',c1='$c1',c2='$c2',c3='$c3',d_1='$d_1',d_2='$d_2',d_3='$d_3',d_4='$d_4',d_5='$d_5',d_6='$d_6',d_7='$d_7',d_8='$d_8',d_9='$d_9',d_10='$d_10',d_11='$d_11',e_1='$e_1',e_2='$e_2',e_3='$e_3',e_4='$e_4',e_5='$e_5',e_6='$e_6',e_7='$e_7',e_8='$e_8',e_9='$e_9',e_10='$e_10',e_11='$e_11',e_12='$e_12',e_13='$e_13',f1='$f1',f2='$f2',f3='$f3',f4='$f4',f5='$f5',f6='$f6',date=now()";
mysql_query($sql) or die(mysql_error());
$mode=$_POST['mode'];
header("location:thank_you.html");
exit;
}
}//submit;
?>
| =$er;?> |