X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Fincludes%2Fdb%2Fitems_codes_db.inc;h=d262ee7120f954ea0a09893c99243f5e2c7ee242;hb=2a0f29497517eca1cde8b2832da5761edefb2268;hp=c349cb1ef09d7c0dffd5ac8b7e13ef8f235bcb23;hpb=d1a5c8a7ba9350def83d4143121bfb0a75f69c5a;p=fa-stable.git diff --git a/inventory/includes/db/items_codes_db.inc b/inventory/includes/db/items_codes_db.inc index c349cb1e..d262ee71 100644 --- a/inventory/includes/db/items_codes_db.inc +++ b/inventory/includes/db/items_codes_db.inc @@ -1,4 +1,14 @@ . +***********************************************************************/ /* item_codes table is used to store both multiply foreign codes and sale kits definition. @@ -15,7 +25,7 @@ function update_item_code($id, $item_code, $stock_id, $description, $category, $ WHERE "; if ($id == -1) // update with unknown $id i.e. from items table editor - "item_code = ".db_escape($item_code) + $sql .= "item_code = ".db_escape($item_code) ." AND stock_id = ".db_escape($stock_id); else $sql .= "id = $id";