confusion with where query and arrays

[eluser]martynrlee[/eluser]
Hi All,

Just struggling with a database query and hoping someone might be able to help:

I am trying to do the following :

Code:

$this->db->where_in('style', $styleArray);

and

$this->db->where_in('paint', $paintArray);

$this->db->get('gallery');

I have tried lots of methods but can only seem to get or_where_in working I guess I need an equivalent method to 'and_where_in'

Any ideas?

Thanks, Martyn.