Welcome Guest, Not a member yet? Register   Sign In
trying to use batch_update()
#10

(This post was last modified: 08-02-2020, 05:24 PM by richb201.)

In reading about group query I found this. But this is still not working any ideas?
````
            $this->db->select('*')->from('employees')
                ->group_start()
                ->where('email', $_SESSION['userid'])
                ->where('campaign', $_SESSION['campaign'])
                    ->or_group_start()
                    ->where('employee_title',  $exclude_string)
                    ->where('job_code',  $exclude_string)
                    ->where('department',  $exclude_string)
                    ->where('role',  $exclude_string)
                    ->group_end()
                ->group_end();
            $this->db->update('employees',$data );
````
proof that an old dog can learn new tricks
Reply


Messages In This Thread
trying to use batch_update() - by richb201 - 07-28-2020, 04:49 PM
RE: trying to use batch_update() - by ojmichael - 07-28-2020, 08:58 PM
RE: trying to use batch_update() - by qury - 07-29-2020, 01:22 AM
RE: trying to use batch_update() - by richb201 - 07-29-2020, 08:32 AM
RE: trying to use batch_update() - by richb201 - 07-29-2020, 11:16 AM
RE: trying to use batch_update() - by richb201 - 07-29-2020, 02:52 PM
RE: trying to use batch_update() - by richb201 - 07-30-2020, 09:19 AM
RE: trying to use batch_update() - by ojmichael - 07-30-2020, 04:17 PM
RE: trying to use batch_update() - by richb201 - 08-01-2020, 09:02 AM
RE: trying to use batch_update() - by richb201 - 08-02-2020, 05:23 PM
RE: trying to use batch_update() - by ojmichael - 08-03-2020, 05:55 PM
RE: trying to use batch_update() - by richb201 - 08-03-2020, 06:06 PM



Theme © iAndrew 2016 - Forum software by © MyBB