Codeigniter - brackets with activerecord?

Question

How to have round brackets symbol in Codeigniter's active record SQL queries? e.g. how to accomplish

SELECT * FROM `shops` WHERE (`shopid` = '10' OR `shopid` = '11') AND `shopid` <> '18'

Answer 1

$where="(`shopid` = '10' OR `shopid` = '11')";

$this->db->where($where, NULL, FALSE);

and for the AND condition use

$this->db->where('shopid <>', '18')

ie

$where="(`shopid` = '10' OR `shopid` = '11')";
$this->db->where($where, NULL, FALSE);
$this->db->where('shopid <>', '18')

Answer 2

I think you could do something like:

$where = "(`shopid` = '10' OR `shopid` = '11')";

$this->db->where($where)  // or statement here
         ->where('shopid <>', '18') // chaining with AND
         ->get('shops');

Not entirely sure about the syntax, I'm writing this off the top of my head. I'll take a look at it when I get home if this doesn't work.