CodeIgniter Active Record +1

Question

how i can do that query:

UPDATE `xxx` SET `xx`=xx+1

with Active Record in Codeigniter ?

Thanks for your help ;-)

possible duplicate of [Increment field of mysql database using codeigniter's active record syntax](http://stackoverflow.com/questions/6373564/increment-field-of-mysql-database-using-codeigniters-active-record-syntax) — Ben Fortune, Aug 26 '14 at 11:46

score 1 · Answer 1 · answered Aug 26 '14 at 11:46

1

Try with the following code:

//$this->db->where('id', 'yourid');
$this->db->set('xx', 'xx+1',FALSE);
$this->db->update('xxx');

answered Aug 26 '14 at 11:46

Jenz

score 1 · Answer 2 · answered Aug 26 '14 at 11:54

1

Try this

$this->db->where('id',$id);
$this->db->update('xxx',array('xx',$xx+1));

answered Aug 26 '14 at 11:54

rajangupta

score 0 · Accepted Answer · answered Aug 26 '14 at 11:48

0

$this->db->where('id', 'yourid');
$this->db->set('xx', '`xx`+1', FALSE);
$this->db->update('xxx');

Note the third parameter in the set function.

This function tells CodeIgniter not to add a backtick (`) on the field.

answered Aug 26 '14 at 11:48

Pupil

3 Answers3