Update the value of a field in database by 1 using codeigniter
$this->db->set('usage', 'usage+1', FALSE);$this->db->where('tag', 'java');$this->db->update('tags');
You can also use something like this
$data = array('usage' => 'usage+1', *other columns*);$this->db->where('tag', 'java');$this->db->update('tags', $data);
UPDATE: $data was not being passed on to update
I find its sometimes simpler to just write the SQL rather than having Active Record build it for me.
$sql = 'update tags set usage=usage+1 where tag=?';$this->db->query($sql, array($tag));