From 637d70b72291e45850270667f6a803e9a1dc6965 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 26 Jun 2013 21:31:54 +0200 Subject: [PATCH] Item Categories: categories table is now sorted by category description. --- inventory/includes/db/items_category_db.inc | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/inventory/includes/db/items_category_db.inc b/inventory/includes/db/items_category_db.inc index 27a4ed6..fc474d5 100644 --- a/inventory/includes/db/items_category_db.inc +++ b/inventory/includes/db/items_category_db.inc @@ -68,7 +68,9 @@ function get_item_categories($show_inactive) { $sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, " .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id"; - if (!$show_inactive) $sql .= " AND !c.inactive"; + if (!$show_inactive) + $sql .= " AND !c.inactive"; + $sql .= " ORDER by description"; return db_query($sql, "could not get stock categories"); } -- 2.30.2