format("Y-m-d"); $prtTime =date('H:i:s'); $tsDate = $prfDate . " ".$prtTime; //echo "Date: ". $prfDate; if(isset($_POST['done'])){ $myCanvassPRFCode = mysql_escape_string($_POST['myCanvassPRFCode']); $getBuyer = mysql_escape_string($_POST['getBuyer']); $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $ItemRecordID = mysql_escape_string($_POST['ItemRecordID']); mysql_result(mysql_query("UPDATE `prf_request_detl` SET `canvass_by` = '$getBuyer',`date_time_pick`='$tsDate' WHERE `header_ref_code`='$UpdatePRFReferenceNumber'"),0); } ?> ".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //} } ?>

".strtoupper($row['header_ref_code'])."

".strtoupper($row['ahg_admin_date'])."

".strtoupper($dealCode)."

".strtoupper($row['item_description'])."

".strtoupper($row['quantity'])."

".strtoupper($reqByLName).", ".strtoupper($reqByFName)."

".strtoupper($canByLName).", ".strtoupper($canByFName)." ".$picTS."

".strtoupper($CatName)."

"; $chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $withMail ='📝'; $attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['header_ref_code']."'"),0); $noMail = '-'; if($chkAttachment > 0){ echo "📑"; }else{ echo $noMail; } echo"