0) { $rs = mysql_fetch_array($rs); extract($rs); $employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english; $rank = $present_rank; $designation = $present_designation; $from_date = $fdate; if($tdate=='--') $to_date='0000-00-00'; else $to_date = $tdate; $punishment_detail = $_REQUEST['detail']; $reason_english = $_REQUEST['reason']; $details_eng = $_REQUEST['S1']; } $temp = explode('/',$_REQUEST['suspension_date']); $suspension_date = $temp[2].'-'. $temp[1].'-'. $temp[0]; /*$res=mysql_query("select max(serial_number) as cnt from suspended_detail"); $tot=0; $row=mysql_fetch_array($res); $tot=$row['cnt']+1; */ $now = time(); // or your date as well $your_date = strtotime($to_date); $datediff = $now - $your_date; $no_days = floor($datediff/(60*60*24)); if($_POST['tdate']=="" || $no_days<0){ mysql_query("update new_posting_detail set transfer_posting_flag='SUS' where personal_number=".$personal_number); } mysql_query("insert into suspended_detail(personal_number, employee_name, rank, designation, reason_english, from_date,To_date, punishment_detail,serial_number,crime_detail,suspension_date) values('$personal_number', '$employee_name', '$rank', '$designation', '$reason_english', '$from_date','$to_date', '$punishment_detail',null,'".$_POST['crime_detail']."','$suspension_date')") or die(mysql_error()); //echo "insert into suspended_detail(personal_number, employee_name, rank, designation, reason_english, from_date,To_date, punishment_detail,serial_number) values('$personal_number', '$employee_name', '$rank', '$designation', '$reason_english', '$from_date','$to_date', '$punishment_detail',null)"; header("Location: confirm_so_add.php?id=".$personal_number); } function findrank($id = null) { $results=mysql_query("select * from rank_master where rank_id=".$id); if($x = mysql_fetch_array($results)) { return $x['rank_eng']; } else { return 'N/A'; } } $results=mysql_query("select * from new_posting_detail where personal_number='".$_REQUEST['id']."' "); $arow=mysql_fetch_array($results); extract($arow); ?> Uttar Pradesh Police Nominol Roll System
जनपद/इकाई का नाम
बैक  |  होम  |  लॉग आऊट  

निलंबन विवरण

पर्सनल नम्बर :

नाम : emp hindi name error = No database selected