FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
".TB_PREF."debtor_trans trans,
FROM ".TB_PREF."stock_master item,
".TB_PREF."stock_category category,
".TB_PREF."debtor_trans trans,
if ($category != 0)
$sql .= " AND item.category_id = ".db_escape($category);
$sql .= " GROUP BY item.category_id,
if ($category != 0)
$sql .= " AND item.category_id = ".db_escape($category);
$sql .= " GROUP BY item.category_id,