format("Y-m-d"); if(isset($_POST['done'])){ $SearchText = mysql_escape_string($_POST['SearchText']); $addByUID = mysql_escape_string($_POST['addByUID']); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`!='Approved' AND `cl_status`='1' AND `cl_h_comp_id` = '$compID' AND `search_ref_lname` LIKE '%$SearchText%' || `cl_h_hr_approval`!='Approved' AND `cl_status`='1' AND `cl_h_comp_id` = '$compID' AND `search_ref_fname` LIKE '%$SearchText%' || `search_ref_emp_id` LIKE '%$SearchText%' ORDER BY `cl_h_date_created` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $uID = $row['cl_h_emp_id']; $pID = $row['cl_emp_position']; $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $count = $count + 1; ?>".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

NO.	TRANS ID.	DATE CREATED.	EMP. ID.	EMPLOYEE NAME	POSITION	TYPE	STATUS
".strtoupper($row['h_id'])."	".strtoupper($row['cl_h_date_created'])."	".strtoupper($uEMPID)."	".strtoupper($uLName).",".strtoupper($uFName)."	".strtoupper($uPosition)."	".strtoupper($row['cl_rank'])."	".strtoupper($row['cl_h_hr_approval'])."

"; //echo ''; exit(); } ?>