".$row['id']."";
echo "| ".strtoupper($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($dealCode)." | ";
echo "".strtoupper($row['purpose_of_request'])." | ";
echo "".strtoupper($row['date_needed'])." | ";
echo "".strtoupper($reqByLName).", ".strtoupper($reqByFName)." | ";
echo "";
$chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['reference_code']."'"),0);
$withMail ='📝';
$attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['reference_code']."'"),0);
$noMail = '-';
if($chkAttachment > 0){
echo "📑";
}else{
echo $noMail;
}
echo" | ";
echo "
";
//}
}
?>