How to add a counter to a MySQL Table?

[eluser]Unknown[/eluser]
i had the same problem, and i still wanted to pass an array to the update function,

using:

Code:

$this->db->set($data, false);

didn't worked.

so i solved it with this code:

Code:

function update($id, $data)
{
   $data = array(
      'click_count' => 'click_count + 1'
   );

   foreach($data as $k => $v)
   {
      $this->db->set($k, $v, false);
   }
   $this->db->where('id', $some_id);
   $this->db->update('ads');
}

hope that helped.