Issue with Query

So I have been trying to figure this out and have hit a wall.

This is the query that the profiler prints out:

Code:

SELECT *
FROM (`employees`)
WHERE `position` = 1
OR `position` = 3
AND `status` = 1
ORDER BY `position` desc  

However, the AND status = 1 gets ignored and I don't understand why.

Code:

SELECT *
FROM (`employees`)
WHERE (`position` = 1
OR `position` = 3)
AND `status` = 1
ORDER BY `position` desc  

Code:

SELECT *
FROM (`employees`)
WHERE (`position` = 1
OR `position` = 3)
AND `status` = 1
ORDER BY `position` desc  

I can't seem to recreate that using Active Record.

My current code is

Code:

$this->db->where("position = 1");
$this->db->or_where("position = 3");

I think that in this case you can use IN instead of OR AND..>

PHP Code:

$this->db->where_in( 'position', array(1,3)); 


If its not option to use IN just write your where cause inline:

PHP Code:

$this->db->where('(position=1 OR position = 3) AND status = 1'); 


Best VPS Hosting : Digital Ocean

This is possible in CodeIgniter 3:

Code:

$this->db
    ->select()  // May be removed, if you select all the fields.
    ->from('employees')
    ->group_start()
        ->where('position', 1)
        ->or_where('position', 3)
    ->group_end()
    ->where('status', 1)
    ->order_by('position', 'desc');

Result SQL:

Code:

SELECT *
FROM `employees`
WHERE   (
`position` = 1
OR `position` = 3
)
AND `status` = 1
ORDER BY `position` DESC

This solved it:

I think that in this case you can use IN instead of OR AND..>

PHP Code:

$this->db->where_in( 'position', array(1,3)); 


Thanks to everyone for helping out!!