Login | Sign up | Toll-Free: 1-800-752-0455



8 posts by 3 authors in: Forums > CMS Builder
Last Post: March 7


Can I have multiple search form fields search the same listing field using an AND operator?

e.g. /search.php?product=Sony&product=HD

-> this will display all listings with "Sony" AND "HD" in the product field.

Will this work or should I be doing this some other way?

Thank you.


By Dave - March 5

Hi Greg, 

Yes, that's what it will do by default so that should work no problem.

Let me know if you have any other questions.

Dave Edis - Senior Developer

Hi Dave,

Thanks for getting back to me. That's great!

And if I want to use an OR operator then I would do this:


Is that right?

Thanks again.


By Dave - March 6

Hi Greg, 

Yes, that's right.  And if you want to see the actual MySQL that is being generated for debugging purposes you can add the option: 

'debugSql' => true,

Hope that helps!

Dave Edis - Senior Developer

Hi Dave,

That's useful to know, thanks.

Also, can you clarify what the difference is (if any) between:




Thank you,


Taking a stab at it, I think product_keyword=HD would find HDMI whereas product=HD would not find it?

Would product=HD and product_match=HD be the same query?


Tim Forrest
Toledoh Enterprises

By Dave - March 7

Hi Guys, 

Yea, that's right.  *_keyword matches if the keyword is anywhere in the value.  Otherwise, it needs to be an exact match.

Reference: https://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Dave Edis - Senior Developer

Thanks guys for your help! Really good to now understand this.