MeNeedz Search

[eluser]zvir[/eluser]
hi, i have one more question. when i enter 'search_default_where' value it creates query like this:

Code:

SELECT search_id_field FROM (search_from) WHERE search_default_where AND db_column[0] LIKE '%test%'
OR  db_column[1] LIKE '%test%' OR  db_column[2]  LIKE '%test%'

and this kind of query ignores 'search_default_where' value. the query works only if i put db_columns in () like this:

Code:

SELECT search_id_field FROM (search_from) WHERE search_default_where AND (db_column[0] LIKE '%test%'
OR  db_column[1] LIKE '%test%' OR  db_column[2]  LIKE '%test%')

so now i'm confused and can't get it to work as i want...

please help...

edit: solved, i edited it to support OR and parentheses. thanks anyway for this great library!