How would you write given query using active record

[eluser]smilie[/eluser]
Although I do agree with Dennis (using AR for 'simple' queries), I think AR could do this as well with: or_where:

$this->db->or_where();

This function is identical to the one above, except that multiple instances are joined by OR:

$this->db->where('name !=', $name);
$this->db->or_where('id >', $id);

// Produces: WHERE name != 'Joe' OR id > 50
Note: or_where() was formerly known as orwhere(), which has been deprecated.

See: http://ellislab.com/codeigniter/user-gui...tml#select (and then a bit bellow on that page).

So, it should be doable

Cheers,
Smilie