-- No record found -- ";
}else{
while($row=mysql_fetch_array($getItemHdr)){
$itmID=$row['id'];
$reqNameID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0);
$dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0);
$catID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0);
$SubcatID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0);
$Category = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='".$catID."'"),0);
$ProposalCount = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_canvass_sheet WHERE `item_id`='$itmID'"),0);
$reqNameFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0);
$reqNameLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqNameID'"),0);
?>
