[iblux]

Hi everyone, I want to use grocery crud to retrieve groups from a database, using their id's, with a query like this:

SELECT * FROM Groups WHERE GroupID IN (3,8,12,23) //etc.

It's quite easy to do when you have a single id with

$crud->where

, but how should I tackle this one with multiple id's?

(btw, thank you web-johnny, for creating such an amazingly simple, and yet extensive crud, keep up the good work! )

[iblux]

Nobody?

[kenvogt]

Try or_where

[iblux]

Thanks! I used a foreach loop:

foreach($data['ids'] as $id)

{

       $crud->or_where('grpId', $id);

}

[mavershim]

or you can try

$crud->where("GroupID in (1,2,3,5)");