or_like problem

[eluser]mah0001[/eluser]
I don't think you can combine the AND and OR the way you want using the Active Record. The alternate is:

Code:

$sql = "SELECT * FROM {$this->db->dbprefix}customers WHERE user_id = ? AND flag_sleep=? AND (firstname like ? OR lastname like ?) order by firstname asc";
$Q=$this->db->query($sql, array($user_id,0, '%'.$search_term.'%', '%'.$search_term.'%'));
return $Q;