Searching entire site

[kkonline]

Hi there,
I have a site which will be growing everyday as users submit their data to the database. The site has 10 different tables for storing articles, quotation, comments, tags, images and many other table .

I want to have a common search for the entire website.

I cannot use union as the parameters for tables and the num of parameters differ.
Example article having title, titletext, content, moral . Then quotation having author and content. images having just title

Please help me how to search the entire site (The logic) or should something like sphider search project be an appropriate and easy way to go

I could have query and the section number (1 for articles, 2 for images, 3 for quotes etc...) passed to a search () as search (1,$query)

and inside that function i'll check the section if one then contents will be displayed fro articles
then i call search (2,$query) to display results for images and so on...

Any better ideas to organise and easy search?

[eelixduppy]

I don't see a problem with your second idea.

Here is a good thread that may help you once you decide how you are going to handle your search: [webmasterworld.com...]