$this->db->set()

[eluser]tyuwan[/eluser]
This may seems small, but I was wonder why this doesn't work?

$this->db->set('count','count+1');
$this->db->where('id',$id);
$this->db->update('table');

[eluser]WanWizard[/eluser]
Do an

Code:

echo $this->db->last_query();

and it will become clear.

'count+1' is taken as a literal and escaped. Check the manual on how to deal with this.

[eluser]Crimp[/eluser]
For ref.

Code:

$this->db->set(‘count’,‘count+1’, FALSE);

[eluser]tyuwan[/eluser]
Awesome, Thank you, I was wondering what was the FALSE for.