".$count."";
echo "".trim($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($prfCompName)." | ";
echo "".strtoupper($prfDealName)." | ";
echo "".strtoupper($prfCatName)." | ";
echo "".strtoupper($prfSubCatName)." | ";
echo "".strtoupper($prfDeptApproverLName).", ".strtoupper($prfDeptApproverFName)." | ";
echo "";
$status = $row['current_status'];
$statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0);
echo $statusName;
echo" | ";
echo "
";
}
?>