or_like problem

[eluser]Burak Guzel[/eluser]
If there is no simpler way of doing it, maybe this could work too:

Code:

function getAllCustomersLikeSearchTerm($search_term, $user_id)
    {
        $this->db->select('*');
        $this->db->from('customers');
        
        $this->db->like('firstname', $search_term, 'both');
        $this->db->where('user_id', $user_id);
        $this->db->where('flag_sleep', '0', FALSE);
        
        $this->db->or_like('lastname', $search_term, 'both');
        $this->db->where('user_id', $user_id);
        $this->db->where('flag_sleep', '0', FALSE);
        
        $this->db->order_by('firstname', 'asc');

        $Q = $this->db->get();
        return $Q;
    }