0){ echo " "; exit(); } if($getItemHdrCount == 0){ echo " "; }else{ while($row=mysql_fetch_array($getItemHdr)){ $myPRFNumber = $row['header_ref_code']; $itmID=$row['id']; $dealID=$row['dealer_id']; $dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $companyID=$row['comp_id']; $companyName =mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$companyID'"),0); $reqNameID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='".$row['header_ref_code']."'"),0); echo ""; $purpose = mysql_result(mysql_query("SELECT `purpose_of_request` 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 " Company: "; echo " Quantity: "; echo " Purpose of Request: ".$purpose." "; echo " (".$ProposalCount.")Click here to view submitted proposals "; echo " "; echo " "; echo " "; echo "	."; echo "
".$row['item_description'].""; //echo "
// View Canvass