".$row['id']."";
echo "| ".strtoupper($row['header_ref_code'])." | ";
echo "".strtoupper($row['ahg_admin_date'])." | ";
echo "".strtoupper($dealCode)." | ";
echo "".strtoupper($row['item_description'])." | ";
echo "".strtoupper($row['quantity'])." | ";
echo "".strtoupper($reqByLName).", ".strtoupper($reqByFName)." | ";
echo "".strtoupper($canByLName).", ".strtoupper($canByFName)."
".$picTS." | ";
echo "".strtoupper($CatName)." | ";
echo "";
$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" | ";
echo "
";
//}
}
?>