Welcome Guest, Not a member yet? Register   Sign In
How to UPDATE DB values using active record?
#1

[eluser]pernavoi[/eluser]
What is active record syntax for following query? amount1 and amount2 are INT values and I want to add values to them from data array

Code:
$this->db->query("UPDATE mytable
SET amount1 = amount1 + '{$data['amount1']}', amount2 =  amount2 + '{$data['amount2']}'
WHERE id = '{$data['id']}'");


Messages In This Thread
How to UPDATE DB values using active record? - by El Forum - 10-30-2010, 06:02 PM
How to UPDATE DB values using active record? - by El Forum - 10-30-2010, 06:22 PM
How to UPDATE DB values using active record? - by El Forum - 10-30-2010, 06:52 PM
How to UPDATE DB values using active record? - by El Forum - 10-31-2010, 06:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB