CodeIgniter SELECT query to find qualifying combinations of values in two specified columns
13:54 25 Aug 2016

I have checked other questions regarding this, but could not resolve issue

$this->db->where(array('sender_deletedS' => 1, 'receiver_deleted' => 0 ));
$this->db->or_where(array('sender_deletedS' => 0, 'receiver_deleted' => 1 ));
$this->db->or_where(array('sender_deletedS' => 0, 'receiver_deleted' => 0 ));
$query2 = $this->db->get('message');

It produces

SELECT *
FROM `message`
WHERE `sender_deletedS` = 1
  AND `receiver_deleted` = 0
   OR `sender_deletedS` = 0
   OR `receiver_deleted` = 1
   OR `sender_deletedS` = 0
   OR `receiver_deleted` = 0

but I want this

SELECT *
FROM `message`
WHERE (`sender_deletedS` = 1 AND `receiver_deleted` =0)
   OR (`sender_deletedS` =0 AND `receiver_deleted` = 1)
   OR (`sender_deletedS` =0 AND `receiver_deleted` =0)
php sql codeigniter where-clause query-builder