How to add a counter to a MySQL Table?

[eluser]thePiet[/eluser]
[quote author="Mohsen32" date="1249046548"]Is this gonna work:

Code:

$data = array(
'click_count' => 'click_count + 1'
);

$this->db->select('click_count')->where('id', $row->id);
$this->db->update('ads', $data);

[/quote]

More something like:

Code:

$data = array(
'click_count' => 'click_count + 1'
);

$this->db->where('id', $some_id);
$this->db->update('ads', $data);

I guess.