X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fincludes%2Fdb%2Fitems_category_db.inc;h=b454b88127da7b9808e239708319b4c008cb2d32;hb=b6ae2ddcd0cbc571edd01157ca1c8d44bbe071ef;hp=25368ee75e12c1357e0e002e74ab686b952af1c6;hpb=7f5a0ac613cd75593cd441a4c522dee1373fc097;p=fa-stable.git

diff --git a/inventory/includes/db/items_category_db.inc b/inventory/includes/db/items_category_db.inc
index 25368ee7..b454b881 100644
--- a/inventory/includes/db/items_category_db.inc
+++ b/inventory/includes/db/items_category_db.inc
@@ -70,7 +70,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");
 }
@@ -94,4 +96,3 @@ function get_category_name($id)
 	return $row[0];
 }
 
-?>
\ No newline at end of file