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

SELECTED RECORD HAS BEEN UPDATED

"; $getAdminList = 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"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getAdminList)){ $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(); } ?>