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

[eluser]wyl_g[/eluser]
i am having some trouble with this code. it keeps writing 1 in my database and if i remove the +1 it doesn't change/update the password. and if i remove the +1 and false params, i get a 1054 error. please help



function set_password($id, $password){

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

if ($this->db->affected_rows() == '1')
{
return true;
}
return false;

}//end set password