format("Y-m-d"); $prtTime =Explode(":", date('H:i:s')); $txDate = explode("-",$prfDate); $refYear = $txDate[0]; $refMonth = $txDate[1]; $refMinute = $prtTime[1]; $refSecond = $prtTime[2]; $NewRefCode = $refMonth.''.$refMinute.''.$refSecond; if(isset($_POST['done'])){ $SelCompanyID = mysql_escape_string($_POST['SelCompanyID']); $SelDelaerID = mysql_escape_string($_POST['SelDelaerID']); $SelCategoryID = mysql_escape_string($_POST['SelCategoryID']); echo ""; echo ""; echo ""; //echo $SelCompanyID; //echo "
".$SelDelaerID; echo ""; ?> "; ?> ".$aRow['id'].""; echo ""; echo ""; echo ""; echo "

".$catName." - ".$aRow['description']."

"; echo ""; echo "".strtoupper($getOldValidatorLName).", ".strtoupper($getOldValidatorFName).""; //$getClearingOfficerList = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,cl_approving_officers.cl_emp_id_a FROM cl_approving_officers JOIN vts_users ON cl_approving_officers.cl_emp_id_a = vts_users.u_id WHERE cl_approving_officers.cl_emp_id_a = vts_users.u_id GROUP BY cl_approving_officers.cl_emp_id_a ORDER BY vts_users.u_lname ASC"); $getClearingOfficerList = mysql_query("SELECT * FROM `vts_users` WHERE approver = 1 AND `u_status`=1 ORDER BY u_lname ASC"); while($row = mysql_fetch_array($getClearingOfficerList)){ echo "".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname']).""; } echo ""; echo "

"; } echo ""; } ?>