or_Like Question

[eluser]toopay[/eluser]
I'm affraid, that you must write the query in a string, because ActiveRecord in CodeIgniter not supporting sub-query (yet). I suspect, you must be need query like...

Code:

$sql = "SELECT * FROM (customer) "
       ."WHERE bb_id = '".$bb_id."' "
       ."AND (fname LIKE '%".$new."%' "
       ."OR lname LIKE '%".$new."%' "
       ."OR email LIKE '%".$new."%') "