how to do this query

[eluser]danmontgomery[/eluser]
AR doesnt' support grouped where statements, you woulud need to do it manually.

Code:

$this->db->where('(`field1` = "'.$var1.'" OR `field2` IS NULL)', null, false)->where('field3', 'some value');