I would like to do and update table field data increment by one when this controller process was trigger. Any one can tell me how to write it in Active Record? i know SQL can do like this
$orders_status_sql = " UPDATE ".Yii::app()->params['TABLE_ORDERS_STATUS_STAT']." SET occurrence=occurrence+".(int)$increment.", latest_date = ".$o_latest_date.",changed_by = '".$record_array['changed_by']."'WHERE orders_id = ".$o_id." AND orders_status_id = ".$o_status_id;