/*include("admin/db.php"); //////////////////top menu///////////////////// $sql_menu="SELECT * FROM `menu` WHERE `pub`='1' ORDER BY `order` ASC"; $result_menu=mysql_query($sql_menu, $conn) or die(mysql_error()); //////////////////top menu///////////////////// /////////////////newsletter insert/////////// if($_REQUEST['newsletter']) { $ms = eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $_REQUEST['newsletter']); $sql_nls="SELECT * FROM `newsletter` WHERE `email`='$_REQUEST[newsletter]'"; $result_nls=mysql_query($sql_nls, $conn) or die(mysql_error()); $num_nls=mysql_num_rows($result_nls); if(($ms==1)&&($num_nls!=1)) { $sql1="INSERT INTO `newsletter` (`email`) VALUES ('$_REQUEST[newsletter]')"; mysql_query($sql1); } } /////////////////newsletter insert///////////*/ ?>
|
|