Update query increment field plus 1 codeigniter

Question

I got a problem when trying to increment by 1 on given field in my db. I tried with and without active records.

My functions look like this (in my model)

function _set_reads($id){
$this->db->set('reads', 'reads+1', FALSE)
$this->db->where('id', $id);
$this->db->update('article');
}

and

function _set_reads($id){
$sql = 'update article set reads=reads+1 where id=?';
$this->db->query($sql, array($id));
}

I get the same error in both cases and it's the following error message:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads+1 WHERE `id` = '15'' at line 1

UPDATE `article` SET `reads` = reads+1 WHERE `id` = '15'

I am using the latest version of MAMP

Answer 1

Solved it: I had to change

$this->db->set('reads', 'reads+1', FALSE)

to

$this->db->set('reads', '`reads+1`', FALSE)

Sorry for the post...

Answer 2

set() will also accept an optional third parameter ($escape), that will prevent data from being escaped if set to FALSE.

Answer 3

-- Need small correction

$this->db->where('id', $id);
$this->db->set('set_row', '`set_row`+ 1', FALSE);

Thank You

Answer 4

This was very helpful to @syyu

$this->db->where('id', $id);
$this->db->set('set_row', '`set_row`- 1', FALSE); // to decrement