Searching articles for hand-picked keywords

There are many ways to implement a search on your site - I asked you to pick from three of them in the search survey I did recently. The method that most people picked entailed me reading every page on the site and hand-picking keywords. These keywords were entered into a new table, ArticlePages. You can get the source code for the entire site, including the database, here.

This table is used for many purposes, not just searching - the data for the breadcrumbs and previous/next page links in the articles are also stored here.

For searching purposes we are interested in just three fields: URL, ShortDescr and Keywords. I'll show you how I created a SSI to display and process the search form, turn the search expression into SQL and display the results.