How to convert this update QUERY to ActiveRecord

[eluser]Christopher Blankenship[/eluser]
First you have to of course obtain the $row['ord_id'] and then this is what I believe you are looking for:

Code:

$data = array(
   'ord_id' => ($row['ord_id'] - 1),
   );
$this->db->where('ord_id >', $row['ord_id']);
$this->db->update('menu', $data);

Basically this will update the field subtracting 1 from it each time it is accessed.