This topic is locked

extra search paramenters field, would like to be an "or" not &

3/8/2011 11:16:00 PM
PHPRunner General questions
M
markb author

Hello
I'm using the feature in the search form that comes with PHPrunner to add extra fields on the fly

my problem is that PHPrunner codes the extra field as an "and" in the sql query and not as an "or"
So if I have the field "city" in the search and I search for "Sydney" it finds all the records that have "sydney as city

If I click on "add field" and I add again "city" so that I can search for two cities example "sydney" and "melbourne"

in this case the search does not find anything (where I would like it to find records that contains or Sydney or Melbourne)
Is it possible to change this behavior?

Is it something I can set in the options of PHPrunner?

Or in the code?
Thanks very much!

Mark

Sergey Kornilov admin 3/9/2011

When you use search panel or advanced search you have a choice between ALL (and) and ANY (or) search. I guess you can choose ANY option to get what you want.