Incrementing a counter in the database

[eluser]Phil Sturgeon[/eluser]
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.