You are here:  » Searching more than one database ?


Searching more than one database ?

Submitted by krispy1812 on Sat, 2006-08-12 16:02 in

Hi,

Is it possible to enable the script to search more than one database ?

I will explain briefly the reason I am asking this.

Different merchants use different category names, and I have noted that some people setup multiple databases to handle the different category searches and use a drop down menu, and each catagory selection searches the appropriate database they select.

However, if a user does not select a particular catgeory from the drop down menu ( and instead uses a site wide search), what database would the search function use to search for the product ?

I hope this makes sense and allows you to figure out what I am getting at.

regards

Submitted by support on Sun, 2006-08-13 09:28

Normally when you would do this you would not give the option to do a site wide search - the user has to select a category. This is not unreasonable, as people would normally know what category their product is likely to be found in.

Unfortunately there is no simple way to simply enable the script to search in multiple databases. It would certainly be possible to do with a custom search script that connected to each database in turn, and then perhaps forwarded to the category site with the most results, or simply returned a list of categories with the number of results in each category displayed.