How to write this query by active record

[eluser]FutureKing[/eluser]
I want to write the following query using active record.

UPDATE `app_term_taxonomy` SET count=count+1 WHERE `tx_id` = '24';

This didn't worked for me.

Code:

$data = array(
               'count' => 'count+1',              
            );
            $this->db->where('tx_id', $tx_id);
            $this->db->update('term_taxonomy', $data);

Please help.

[eluser]breizik[/eluser]
Hi,

the method $this->db->set should do the trick:

Code:

$this->db->set('count', 'count+1', false); // I think the last param false is needed to avoid quotation problems
$this->db->where('tx_id', $tx_id);
$this->db->update('term_taxonomy');

[eluser]FutureKing[/eluser]
thanks it worked for me.