query("select * from $tbl_newsletter where email='$email' and status=1 "); $emailNumRows = $obj->numRows($emailArr); if($emailNumRows>0){ $_SESSION['sess_msg']='Email Allready added'; }else{ $obj->query("insert into $tbl_newsletter set email='$email',subscribe_date='".date('Y-m-d h:i:s')."',status=1 "); $_SESSION['sess_msg']='Subscriber added sucessfully'; } }else{ $emailArr = $obj->query("select * from $tbl_newsletter where email='$email' and status=1 "); $emailNumRows = $obj->numRows($emailArr); if($emailNumRows>0){ $_SESSION['sess_msg']='Email Allready added'; }else{ $sql="update $tbl_newsletter set email='$email' "; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Subscriber updated sucessfully'; } } header("location:subscriber-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from $tbl_newsletter where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?>

Admin: Edit Add Subscriber Email :