Update using WHERE

https://codeigniter.com/user_guide/model...aving-data

Thanks, but again nothing on there explains my situation.

Closest thing is this:

PHP Code:

$userModel
    ->whereIn('id', [1,2,3])
    ->set(['active' => 1])
    ->update(); 


Where you can set multiple rows, but you have to pass all the ids in.

In my situation I would have to query the db for all the rows where activity_id = X
Then convert that to an array of the ids and then do the above query.

Thanks though.