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
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
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
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gversion] Searching 2 tables at the same time
By gversion - January 4, 2013
Hi Jerry,
Thanks for the attachment, this is very helpful.
Kind regards,
Greg