Incrementing a counter in the database

[eluser]Phil Sturgeon[/eluser]
Strange. The following works so I assumed that would:

Code:

$this->db->update('table', 'offence_count = offence_count + 1', array('id', 10));