Multi-Search functions

2 posts by 2 authors in: Forums > CMS Builder
Last Post: June 4, 2009 (RSS)

Archived
Reply
Reply

By rentittoday - June 3, 2009

Hello,

We have created a keyword search using a multi-search (attached).
Right now it searches various fields , for example, in the Scooter Rentals table it searches: name, full_description, short_description, company_name, subcategory, metro_area, city, state, zip, country.

If a user types in "Scooter Rentals" it does not pull all items in the scooter rentals category, only those that have "scooter rentals" in the description.

We would like to have the multi-search function search the CMS table names as well. So if a user typed in, for example, scooter rentals it would pull ALL items in the scooter rental category.

I have tried to get it to search tableName, but would always get an error. Is this possible to do? and how? [:)]

thanks,
Lauren

Jason Glass

Attachments:

multisearch_002.php 27K

Re: [rentittoday] Multi-Search functions

Archived
Reply
Reply

By ross - June 4, 2009

Hi Lauren

Thanks for posting!

The way you have your search setup right now, it's really designed to do the multi table search. If you wanted to have a way to lock it down to just one specific section, I think you would be better off with a separate search.

One would be to do keyword searching in all sections, the other would be to do a search in one specific section.

Now, if you really wanted (or needed) to have this all done in one form, there are some options there too but it will start getting prety tricky.

Let me know what you think and we'll go from there. Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/