Incrementing a counter in the database

[eluser]franto[/eluser]
[quote author="Phil Sturgeon" date="1243619735"]Some advice that will solve every problem you ever have with running MySQL from PHP.

1.) Output the final query and see if it looks right.

Code:

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

2.) If it looks fine, try running it in phpMyAdmin or another GUI.

3.) If it runs fine, your PHP is not running the query correctly (don't find this one happening so often).

4.) If it fails, you get an error message telling you what's wrong. Then, correct your query.

Debugging my friend, is a wonderful thing.[/quote]

Thanks for help, I'm newbie in Code Igniter, and didnt know how to write SQL statement from Active Record. I have to confess Im Senior Flex developer and I'm used to debug daily many hours but I'm not developing in PHP so much, this is just my sideproject

btw here is result:

UPDATE `wtu_messages` SET `offence_count` = 'offence_count + 5' WHERE `id` = '2'

problem is with difference quotes in SET part. It should be

UPDATE `wtu_messages` SET offence_count = offence_count + 5 WHERE `id` = '2'

But I don't know how to write it via Active record, so I will rather try to create SQL statement as a string. Or maybe you know how to fix it via Active Record?