format("Y-m-d"); if(isset($_POST['done'])){ $selectedEmpID = mysql_escape_string($_POST['selectedEmpID']); mysql_query("UPDATE `vts_users` SET `approver`='1' WHERE `u_id`='$selectedEmpID'"); //echo "

SELECTED RECORD HAS BEEN UPDATED

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `approver` = 1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getApproverList)){ $count = $count + 1; ?>".$row['u_id'].""; echo ""; echo ""; echo ""; echo ""; } echo "

REC.ID.	LAST NAME	FIRST NAME	POSITION
".strtoupper($row['u_lname'])."	".strtoupper($row['u_fname'])."	".strtoupper($row['u_position'])."

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