"; while($row = mysql_fetch_array($qq)){ echo ""; $itemID =$row['item_id']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo "

".$branchName."";?> " . $branchAddress ."";?> ADVANCE PAYMENT UTILIZATION REPORT Name of Patient:
"; echo "
Date Paid	Payment. No.	Name of Patient	Item Description	QTY	Paid Amount	Date Used
"; $getDate = mysql_result(mysql_query("SELECT `date` FROM `advance_payment` WHERE `OR_number`='$or'"),0); echo $getDate; echo "	"; $getOR = mysql_result(mysql_query("SELECT `OR_number` FROM `advance_payment` WHERE `OR_number`='$or'"),0); echo $getOR; echo "	"; echo $lName.", ".$fName; echo "	"; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); echo $itemDesc; echo "	"; echo $row['qty']; echo "	"; echo number_format($row['used_amount'],2,'.',','); $totalAmount = $totalAmount + $row['used_amount']; echo "	"; echo $row['date']; echo "
".number_format($totalAmount,2,'.',',')."

"; ?>