Welcome to WebmasterWorld Guest from 18.104.22.168
I'm in the process of creating my own directory, and one of the things I would like to do is to create a search script when you type in a search term and queries the DB.
The results will show the title, description, and the category which the search term belongs to.
Now I'm not quite sure whether I need to do some alterations to the DB, so that it allows the script to search the text quickly, some indexing change etc.
Are there any tutorials or ready made scripts out there in which I can alter to my needs?
This is something I've never grasped as a developer, and really interested how this is achieved.
Any suggestions is appreciated.
Like for already searched results, built a keywords phrases vs URIs tables that is looked up second time, when required.
The whole databse system should be re-loaded and your Web site need be crawled, after some time (may be via a cron), say 1 week (if changes are fast), or monthly basis (if there are few changes) or almost everyday, if content is changing all the time.
Much time should be spent in database design for such a project. I suppose it, may be a dozen relational database tables. Good luck.