0){ mysql_query("update emp_remain_leave set rem_leave=". $_REQUEST['left_leave']." where personal_number=".$_REQUEST['personalno']." and leave_type=".$ltype); }else{ mysql_query("Insert into emp_remain_leave values(".$_REQUEST['personalno'].",'".$ltype."',".$_REQUEST['left_leave'].")"); } $leave_type = $_REQUEST['ltype']; $from_date = $fdate; $to_date = $tdate; $taken_leave_days = $_REQUEST['total_leave']; $left_leave_days = $_REQUEST['left_leave']; $REMARK = $_REQUEST['remark']; mysql_query("update leave_detail set leave_type = '".$_REQUEST['ltype']."', from_date= '$fdate', to_date= '$tdate', taken_leave_days= '".$_REQUEST['total_leave']."', left_leave_days = '".$_REQUEST['left_leave']."' WHERE serial_number = ".$_REQUEST['id']) or die(mysql_error()); header("Location: confirm_edit.php?id=".$_REQUEST['personalno']); } function findrank($id = null) { $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']; } else { return 'N/A'; } } $results=mysql_query("select key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date from new_posting_detail where personal_number='".$_REQUEST['id']."' ") or die(mysql_error()); $arow=mysql_fetch_array($results); if(is_array($arow)) extract($arow); ?>

जनपद/इकाई का नाम बैक  |  होम  |  लॉग आऊट

No database selected