Fixed SQL quotation.
authorJanusz Dobrowolski <janusz@frontaccounting.eu>
Wed, 13 May 2009 14:06:03 +0000 (14:06 +0000)
committerJanusz Dobrowolski <janusz@frontaccounting.eu>
Wed, 13 May 2009 14:06:03 +0000 (14:06 +0000)
inventory/includes/db/items_db.inc

index dae24ac7d75ab1b7a2ffeb75adc5d0085895cff1..410ed9904d972178c69820c7eb3263b89ff95d98 100644 (file)
@@ -27,10 +27,10 @@ function update_item($stock_id, $description, $long_description, $category_id,
                tax_type_id=$tax_type_id";
 
        if ($units != '')
-               $sql .= ", units=$units";
+               $sql .= ", units='$units'";
 
        if ($mb_flag != '')
-               $sql .= ", mb_flag=$mb_flag";
+               $sql .= ", mb_flag='$mb_flag'";
 
        $sql .= " WHERE stock_id='$stock_id'";