How can I update multiple rows using active record?
My array
foreach($services as $service){
$this->service_batch[]=array(
'service_id'=>$service->service_id,
'service_count'=>$service->service_count,
'id_customer'=>$service->id_customer,
'id_section'=>$service->id_section);
}
When I update the table, I need define 2 parameters in the WHERE
clause (id_customer AND id_section), but if I use update_batch
, I can specify only one parameter.
How can I set a few parameters in the WHERE
clause?