session_start(); include '../conn.php'; function findrank($id = null) { if($id == '') return $id; $results=mysql_query("select * from rank_master where rank_id=".$id) or die(mysql_error()); if($x = mysql_fetch_array($results)) { return $x['rank_eng']; } } if(isset($_REQUEST["B1"])) { $transfer_date=$_POST['transfer_date_yr'].'-'.$_POST['transfer_date_m'].'-'.$_POST['transfer_date_d']; /* Array ( [transfer_date_d] => 25 [transfer_date_m] => 4 [transfer_date_yr] => 1955 [return] => P [Personal_number] => 000470025 [Employee_name] => BHARAT (DHOBI) [Present_rank] => 15 [Present_designation] => [orderno] => 12122 [B1] => Submit [PHPSESSID] => 8334eea4ea5ac80f3733148d6dffdaf0 ) */ $rs = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['Personal_number']); if(mysql_num_rows($rs) == 0) { echo "Recored does not exist in Posting master"; exit(0); } else { mysql_query('update new_posting_detail set transfer_posting_flag = \'T\', transfer_order_date = \''.$transfer_date.'\', order_no = \''.$_REQUEST['orderno'].'\' where personal_number = '.$_REQUEST['Personal_number']); header("Location: ../posting_detail/search2.php?saved=1&page=".$_SESSION['page']."&c=".$_SESSION['c']."&k".$_SESSION['k']); exit(0); } } if(!isset($_REQUEST['pno'])) { header('Location: ../posting_detail/search1.php'); exit(0); } //echo 'select * from new_posting_detail where personal_number = '.$_REQUEST['pno']; $rsq = mysql_query('select * from new_posting_detail where personal_number = '.$_REQUEST['pno']); $rsq = mysql_fetch_array($rsq); if($rsq['transfer_posting_flag']=='T') { header('Location: transfer1.php?pno='.$_REQUEST['pno']); exit(0); } $results=mysql_query("select * from employee_master where personal_number='".$_REQUEST['pno']."' ") or die(mysql_error()); if(mysql_num_rows($results)==0) { $_SESSION['error1'] = true; header("Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/posting.php" ); exit; ?> } $arow=mysql_fetch_array($results); extract($arow); if($unit_name == $_SESSION['Unit']) {} else { header('Location: search1.php'); exit(0); } ?>