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.

You might also like...



Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There are only 3 numbers of interest to a computer scientist: 1, 0 and infinity”