if(isset($_POST['login-submit'])) { $username=$_POST['mobilenumber_12']; $username = str_replace(' ', '', $username); $username = preg_replace('/\s/', '', $username); date_default_timezone_set('Asia/Kolkata'); $date_new_123 = date('Y-m-d H:i:s', time()); // $password=$_POST['password']; $query_pag_num = "DELETE FROM tbl_mobile_ot where mobile_no='$username' "; $result_pag_num = mysql_query($query_pag_num); //$rows = mysql_num_rows($result_pag_num); echo $Insert_member = "INSERT INTO tbl_mobile_ot( `mobile_no` , `o_id` , `mid` , `status` ) VALUES ('$username','$username','$date_new_123','1')"; $inexe=mysql_query($Insert_member); $attachmentfileid = mysql_insert_id(); header("location:login-mobile1.php?sucess=sucess"); } ?> if($_REQUEST['error']=='error') { ?>