0){
$rs = mysql_fetch_array($rs);
if($_POST['status']){
$getRs=mysql_query("select Joining_Unit_Name,Joining_Sub_Unit_Name from transfer_detail where Personal_number=".$_REQUEST['Personal_number']." order by Serial_number desc limit 0,1");
while($rows=mysql_fetch_array($getRs)){
$join_unit=$rows[0];
$sub_join_unit=$rows[1];
}
if($rs['transfer_posting_flag'] == 'T') {
mysql_query("update temp_itransfer_detail set transfer_posting_flag = 'TP', release_date = '".$Release_date."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
mysql_query("delete from new_posting_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
mysql_query("insert ignore into new_posting_detail select * from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']);
mysql_query("INSERT INTO other_transfer_detail (personal_number ,HOB_number ,DD_no ,DD_date) VALUES ('".$_REQUEST['Personal_number']."', '".$_REQUEST[hob]."', '".$_REQUEST[draft]."', '".$Draft_date."')");
// echo "INSERT INTO other_transfer_detail (personal_number ,HOB_number ,DD_no ,DD_date) VALUES ('".$_REQUEST['Personal_number']."', 'fdsf', 'dsf', '2008-11-27')";
// mysql_query("update new_posting_detail set transfer_posting_flag = 'TP',joining_unit='".$join_unit."',joining_sub_unit='".$sub_join_unit."' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
header("Location: confirm_transfer1.php");
exit(0);
}
}else{
// echo "update new_posting_detail set transfer_posting_flag = 'P' where personal_number = ".$_REQUEST['Personal_number'];
mysql_query("update new_posting_detail set transfer_posting_flag = 'P' where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
mysql_query("delete from temp_itransfer_detail where personal_number = ".$_REQUEST['Personal_number']) or die(mysql_error());
header("Location: confirm_transfer1.php");
exit(0);
}
}
}
function findrank($id = null){
if($id == '') return $id;
$results=mysql_query("select rank_eng from rank_master where rank_id=".$id) or die(mysql_error());
if($x = mysql_fetch_array($results)) return $x['rank_eng'];
}
$rsq = mysql_query('select transfer_posting_flag,order_no,transfer_order_date from temp_itransfer_detail where personal_number = '.$_REQUEST['pno']);
$rsq = mysql_fetch_array($rsq);
if($rsq['transfer_posting_flag']=='P'){
header('Location: transfer.php?pno='.$_REQUEST['pno']);
exit(0);
}
$orderdate = $rsq['transfer_order_date'];
$orderno = $rsq['order_no '];
$results=mysql_query("select * from temp_itransfer_detail 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);?>
Uttar Pradesh Police Nominol Roll System