From d1a5c8a7ba9350def83d4143121bfb0a75f69c5a Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 8 Dec 2008 20:45:46 +0000 Subject: [PATCH] Fixed broken syntax in delete_item_code(). --- inventory/includes/db/items_codes_db.inc | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/inventory/includes/db/items_codes_db.inc b/inventory/includes/db/items_codes_db.inc index a5946c64..c349cb1e 100644 --- a/inventory/includes/db/items_codes_db.inc +++ b/inventory/includes/db/items_codes_db.inc @@ -35,7 +35,7 @@ function add_item_code($item_code, $stock_id, $description, $category, $qty, $fo function delete_item_code($id) { - $sql="DELETE FROM ".TB_PREF."item_codes WHERE id=$id"; + $sql="DELETE FROM ".TB_PREF."item_codes WHERE id='$id'"; db_query($sql,"an item code could not be deleted"); } @@ -145,8 +145,7 @@ function get_where_used($item_code) $sql = "SELECT item_code, description FROM " .TB_PREF."item_codes " . " WHERE stock_id='$item_code' - AND item_ - code!='$item_code'"; + AND item_code!='$item_code'"; return db_query($sql, "where used query failed"); } ?> \ No newline at end of file -- 2.30.2