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? |
Messages In This Thread |
Problem with arithmetic operations and active record - by gustavo81988 - 10-30-2015, 03:55 PM
RE: Problem with arithmetic operations and active record - by pdthinh - 10-30-2015, 08:27 PM
|