format("Y-m-d"); if(isset($_POST['done'])){ $selectedApprovingID = mysql_escape_string($_POST['selectedApprovingID']); mysql_query("UPDATE `vts_users` SET `approver` = 0 WHERE `u_id`='$selectedApprovingID'"); echo ""; 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 ""; } echo "

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

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