format("Y-m-d"); if(isset($_POST['done'])){ $SearchEmployees = mysql_escape_string($_POST['SearchEmployees']); $lookUp = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `u_lname` LIKE '%$SearchEmployees%' AND `approver`= 1 || `u_fname` LIKE '%$SearchEmployees%' AND `approver`= 1 "); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($lookUp)){ $count = $count + 1; ?>".$row['u_id'].""; echo ""; echo ""; echo ""; echo ""; } echo "
REC.ID.LAST NAMEFIRST NAMEPOSITION
".strtoupper($row['u_lname'])."".strtoupper($row['u_fname'])."".strtoupper($row['u_position'])."
"; //echo ''; exit(); } ?>