Problem with arithmetic operations and active record |
Hi guys i need to make this query UPDATE `php_items` SET `item_quantity` = `item_quantity` - 10 WHERE `item_id` = 1 using the active record class and i have tried this:
$quantity = -10; $data = array( 'item_quantity' => 'item_quantity'.$quantity, ); $this->db->where('item_id', 1); $this->db->update('php_items', $data); But it returns: UPDATE `php_items` SET `item_quantity` = 'item_quantity-10' WHERE `item_id` = 1 What am i doind wrong? (10-30-2015, 03:55 PM)gustavo81988 Wrote: Hi guys i need to make this query UPDATE `php_items` SET `item_quantity` = `item_quantity` - 10 WHERE `item_id` = 1 using the active record class and i have tried this: You should disable auto-escape like following: PHP Code: $this->db->set('item_quantity', 'item_quantity - 10', FALSE); Read more http://www.codeigniter.com/user_guide/da...ating-data |
Welcome Guest, Not a member yet? Register Sign In |