".$count."";
echo "| ".strtoupper($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($prfCompName)." | ";
echo "".strtoupper($prfDealName)." | ";
echo "".strtoupper($prfCatName)." | ";
echo "".strtoupper($prfSubCatName)." | ";
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 "
";
}
//##################################################################################################################################################################################
?>