format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $SelExecomID = mysql_escape_string($_POST['SelExecomID']); mysql_query("UPDATE prf_poapprover SET deleted = 1 WHERE id='$SelExecomID'"); } echo ""; $getExecomList = mysql_query("SELECT vts_users.u_id,vts_users.u_fname,vts_users.u_lname,prf_poapprover.id,prf_poapprover.po_officer_id,prf_poapprover.authority,prf_poapprover.comp_id FROM `vts_users` JOIN `prf_poapprover` ON `prf_poapprover`.po_officer_id = vts_users.u_id WHERE `vts_users`.u_id=`prf_poapprover`.po_officer_id AND `prf_poapprover`.deleted=0"); while($row=mysql_fetch_array($getExecomList)){ ?> ".$row['id'].""; echo ""; } echo "

".$row['u_lname'].", ".$row['u_fname']."

".$row['authority']."

❌

"; exit(); ?>