[abhishek]

I want to add multiple values in where clause.

 

------------As In Sql , we do like this------------------

SELECT column_name(s)

FROM table_name

WHERE column_name IN (value1,value2,...)

------------------------------------------------------------

How to use this in grocery crud..??

[victor]

you have the same fields in both tables.
you can type like this:
tablename.column, tablename.column2
or you can rename fields

[davidoster]

You can have multiple where

http://www.grocerycrud.com/documentation/options_functions/where

 

$crud->where('status','active');

$crud->where('name !=', $name);

$crud->where('job =', $job);

 

or you can do this

 

$where = "name='Joe' AND status='boss' OR status='active'";
$crud->where($where);

[victor]

sorry I did not read the question carefully

[kenshicu]

see  /topic/1797-taking-where-in-function-in-codeigniter-to-gc/