"; while($row = mysql_fetch_array($qq)){ echo ""; $count=$count + 1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

NO	PATIENT ID	DATE	TIME	ITEM DESC	QUANTITY	ISSUED BY	REMARKS
".$count."	".$row['patient_id']."	".$row['payment_date']."	".$row['payment_time']."	"; $itemID = $row['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$itemID'"),0); echo $itemDesc; echo"	".$row['quantity']."	".$row['payment_by']."	".$row['remarks']."