Yearly Medicine Expense Report

$value) { $newCat = true; $query = "select tbl_items.item_id, tbl_items.item_name, item_stock.stock_qty from tbl_items left join (select item_stock.item_id,sum(item_stock.stock_qty) as stock_qty from item_stock group by item_id) item_stock on item_stock.item_id=tbl_items.item_id where tbl_items.cat='$value' and tbl_items.status= '1' "; error_log("###########QQQQQQQQ" . $query); $result = mysqli_query($conn,$query); $total = mysqli_num_rows($result); if ($total != 0) { ?>

MONTHLY WISE MEDICINE RECEIVED BY OHC																MONTHLY WISE EXPENCES OF MEDICINE
RECEIVED																ISSUED
YEAR: -																YEAR: -
SL.NO	ITEMS	PREVIOUS STOCK			Total Rec.			Total Issue	Expired Stock	Current Stock