-- 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); ?>".$row['id'].""; echo ""; echo ""; // echo ""; } } ?>

"; echo " "; echo " "; echo " Record ID: "; echo " Requestor: "; echo " Date Needed: "; echo " Item Description: ".$row['item_description']." "; echo " Category: "; echo " Quantity: "; echo " Proposal: "; echo " "; echo " "; echo " "; echo "

".$row['item_description'].""; //echo "

// View Canvass