X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=inventory%2Fincludes%2Fdb%2Fitems_units_db.inc;h=d90b03b39e18944493aa4819da6826d756e49cb2;hb=4a4bc22aa76fd989f2c005102bd3da8e0327e547;hp=c06aeafb775d4f3090b7221a6d169948a2b41185;hpb=ebc600101ceab69c06eac4b1bd4d1782af45de05;p=fa-stable.git diff --git a/inventory/includes/db/items_units_db.inc b/inventory/includes/db/items_units_db.inc index c06aeafb..d90b03b3 100644 --- a/inventory/includes/db/items_units_db.inc +++ b/inventory/includes/db/items_units_db.inc @@ -43,9 +43,9 @@ function get_item_unit($unit) function get_unit_descr($unit) { - $sql = "SELECT description FROM ".TB_PREF."item_units WHERE abbr=".db_escape($unit); + $sql = "SELECT name FROM ".TB_PREF."item_units WHERE abbr=".db_escape($unit); - $result = db_query($sql, "could not unit description"); + $result = db_query($sql, "could not retrieve unit description"); $row = db_fetch_row($result); return $row[0]; @@ -64,7 +64,7 @@ function get_all_item_units($all=false) { $sql .= " ORDER BY name"; return db_query($sql, "could not get stock categories"); } -// 2008-06-15. Added Joe Hunt to get a measure of unit by given stock_id +// 2008-06-15. Added to get a measure of unit by given stock_id function get_unit_dec($stock_id) { $sql = "SELECT decimals FROM ".TB_PREF."item_units, ".TB_PREF."stock_master @@ -75,4 +75,3 @@ function get_unit_dec($stock_id) return $row[0]; } -?> \ No newline at end of file