[PHP] codeigniter where

#1$this->CI->db->where('group_id',1);
$this->CI->db->where('group_id',2);
$this->CI->db->where('group_id',3);

select * from table where group_id = 1 and group_id = 2 and group_id = 3

....

kakšen je ukaz, da namesto and uporabim OR??

torej:

select * from table where (group_id = 1 or group_id = 2 or group_id = 3)

#2or_where

http://codeigniter.com/user_guide/database/active_record.html

$this->db->where('name !=', $name);
$this->db->or_where('id >', $id);

// Produces: WHERE name != 'Joe' OR id > 50

#3ne, zadeva ne pali... sem probal.

#4$this->CI->db->where('group_id',1);
$this->CI->db->or_where('group_id',2);
$this->CI->db->or_where('group_id',3);

to ne gre? javi kakšno napako ali izpiše query?

#5ne, zgenerira napačen query. rešitev je edino...

$this->CI->db->where("(group_id='1' or group_id='2' or group_id='3')");

#6A lahko daš kodo, kako si probal...

#7slimdeluxe poglulal sem in poiskal en podoben primer.

#8or_where je nesporno to kar si iskal, zanimalo me je, kaj za eno kodo si napisal, da ti ni delalo prav.

#9$ids = array(1,2,3);
$this->CI->db->where_in('group_id', $ids);