Can I search against more than one value in a field?

3 posts by 2 authors in: Forums > CMS Builder
Last Post: November 5, 2010   (RSS)

By willydoit - November 4, 2010

Hi all,

I have a number of links on a website which produce listings based on simple search criteria such as http://www.bridlington.net/listings/business_list.php?business_type=Cafe or http://www.bridlington.net/listings/business_list.php?business_type=Restaurant what I would like to be able to do is now produce a list which includes both restaurants and cafes, what syntax do I need to have the "or" functionality ie "display if business_type = Cafe or Restaurant."

Thanks in advance

Re: [willydoit] Can I search against more than one value in a field?

By Jason - November 4, 2010

Hi,

This will take some customization since you're trying to search multiple values on the same field and there isn't a way to automatically do that.

If you could attach business_list.php to this post I can take a look and give you some more specific examples of how we can do this.

Thanks
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Can I search against more than one value in a field?

By willydoit - November 5, 2010

Thanks Jason,

If the search cannot be generated from the link then it would be simpler for me to add an extra field such as "food supplier" and search on that.

At least you saved me hours of pulling my hair out.

Thanks