include "../conn.php";
function formatDateField($date){
if($date=='0000-00-00' || $date=='')
return '';
$strArray=explode("-",$date);
$newDate=$strArray[2]."/".$strArray[1]."/".$strArray[0];
return $newDate;
}
function findrank1($pno){
if($pno == '') return $pno;
//echo "select rank_hin from rank_master where rank_id=(select confirmation_rank from employee_master where personal_number=".$pno.")";
$results=mysql_query("select rank_hin from rank_master where rank_id=(select rank from employee_master where personal_number=".$pno.")") or die(mysql_error());
if($x = mysql_fetch_array($results)) return $x['rank_hin'];
}
include("../db_functions/report_function.php");
if($_REQUEST['pno']!=null){
$soQuery=mysql_query("SELECT personal_number,from_date, to_date, going_to, returnn, return_on, comment FROM deputation_record WHERE personal_number='".$_REQUEST['pno']."' ORDER BY from_date");?>