Searching 2 tables at the same time

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 4, 2013   (RSS)

By gversion - October 20, 2012

Hello,

I have a search form that currently displays the matching records from a table called "cms_listings".

So if I search for "widget" then all listings with "widget" in their name display. This is great.

However, all the "widget" listings belong to a category called "Widgets" (stored in "cms_categories").

Currently if someone searches for "Widgets" then no search results are displayed.

Is it possible to have a single search text field that will return results from my "cms_listings" table and my "cms_category" table?

Thank you,
Greg

Re: [gversion] Searching 2 tables at the same time

By gkornbluth - October 22, 2012

Hi Greg,

I've attached a multiSearch file that was posted on the forum (don't remember exactly where). It might be what you're looking for.

If you search for posts with MultiSearch there are lots of entries.

Hope this helps.

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Attachments:

multisearch.zip 2K