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?
Searching entire site
Moderator: General Moderators
Yes, build your search form, and then build the SQL based on input from the form.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.