format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $newGM = mysql_escape_string($_POST['newGM']); $userID = mysql_escape_string($_POST['userID']); $prfCode = mysql_escape_string($_POST['prfCode']); $gmFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$newGM'"),0); $gmLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$newGM'"),0); mysql_query("UPDATE `prf_request_hdr` SET `approving_GM_id`='$newGM' WHERE `reference_code`='$prfCode'"); mysql_query("UPDATE `prf_validate_links` SET `uid`='$newGM' WHERE `po_code`='$prfCode' AND `completed`=0"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Change Approving GM','{$userID}','','{$newGM}','{$prfCode}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== echo "

CURRENT: ".$gmLName.", " .$gmFName."

"; } ?>