Combining AND & OR in MySQL Queries

[eluser]sideshowbob[/eluser]
Thanks a lot, the SQL "in" statement was the key.

Here's my solution:

Code:

$arrFirstnames = array('Tove','Ola');

$this->db->from('Persons');
$this->db->where('LastName','Svendson');
$this->db->or_where_in('FirstName',$arrFirstnames);

Produces :

Code:

SELECT * FROM Persons
WHERE 'FirstName' IN ('Tove', 'Ola') AND 'LastName' = 'Svendson'

Bob