Multiple WHERE conditions with one OR - Codeigniter

Question

I was wondering how to have the first condition constant and only the two bottom conditions as or in codeigniter. It seems to ignore the first condition when the or_where condition is there. How can I specify only the or to apply to the "where private"?

$this->db->where_in('user_id', $followers);

$this->db->where("private", "no");

$this->db->or_where("private", "yes");

Thanks

score 2 · Accepted Answer · answered Feb 14 '14 at 08:37

2

Unfortunately you can't do that using CodeIgniter's ActiveRecord functions. ActiveRecord doesn't have the capability for brackets around where statements as such.

You can manually write this like so:

$this->db->where('(`private` = "no" OR `private` = "yes")');

answered Feb 14 '14 at 08:37

Ryan

3,552
1
22
39

As someone who just used this a couple of minutes ago, this is true. – Chitowns24 Feb 14 '14 at 08:43

score 2 · Answer 2 · answered Feb 14 '14 at 08:38

2

I think this should do the trick:

$this->db->where("(private='no' OR private='yes' )");

answered Feb 14 '14 at 08:38

Muhammad Zeeshan

8,722
10
45
55

Multiple WHERE conditions with one OR - Codeigniter

2 Answers2