format("Y-m-d"); if(isset($_POST['done'])){ $selectedAdminID = mysql_escape_string($_POST['selectedAdminID']); $addCompID = mysql_escape_string($_POST['addCompID']); mysql_query("UPDATE `vts_users` SET `CL_ADM` = 0 WHERE `u_id`='$selectedAdminID'"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $getApproverList = mysql_query("SELECT `u_id`, `u_fname`, `u_lname`, `u_position` FROM `vts_users` WHERE `CL_ADM`= 1 AND `company`='$addCompID' 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(); } ?>