Active Record: add +1 to current value (update)

[eluser]cahva[/eluser]
If you're trying to update the password with a new one, then you should do it like you normally update a record:

Code:

$this->db->set('password', $password);
$this->db->where('id', $id);
$this->db->update('workers');

..or

Code:

$arr = array(
    'password' => $password
);
$this->db->where('id', $id);
$this->db->update('workers',$arr);

The initial problem for this thread is that the user wanted to update the existing record incrementing it by one. The third parameter false will tell CI not to escape the generated SQL and therefore you can do somefield=somefield+1. Without the third parameter set to false, CI would create the sql like: somefield='somefield + 1' which is not the same.