X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fincludes%2Fdb%2Fitems_units_db.inc;h=486db56219e16311b0847684520ae1e092f470be;hb=7607c4c0fb940c7228444eb2b3270d38cfcb42ab;hp=e1841f1cd8508a2fc8e1ae031639e5bd86fcae1f;hpb=95ff74b5722826544743a01daf527aa3c9efe11a;p=fa-stable.git diff --git a/inventory/includes/db/items_units_db.inc b/inventory/includes/db/items_units_db.inc index e1841f1c..486db562 100644 --- a/inventory/includes/db/items_units_db.inc +++ b/inventory/includes/db/items_units_db.inc @@ -43,12 +43,12 @@ 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]; + return is_array($row) ? $row[0] : false; } function item_unit_used($unit) { @@ -72,6 +72,6 @@ function get_unit_dec($stock_id) $result = db_query($sql, "could not get unit decimals"); $row = db_fetch_row($result); - return $row[0]; + return is_array($row) ? $row[0] : false; }