"; while($row = mysql_fetch_array($qq)){ echo ""; $itemID = $row['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); $uom = mysql_result(mysql_query("SELECT `UoM` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$companyName."";?> " . $branchAddress ."";?> DELIVERY RECEIVING REPORT Delivery Date
D.R Number: Invoice Number: D.R Date: Received From: Delivered To:
"; echo "
Record No	D.R Date	Item ID	Item Description	UoM	Quantity	Status
" . $row['detl_id'] . "	" . $row['detl_date'] . "	" . $row['item_id'] . "	" . $itemDesc. "	" . $uom. "	" . number_format($row['detl_qty'],2,'.',',') . "	" . $row['detl_status'] . "

"; ?>