OK, i am stumped; or a case of too much PHP...

i am trying to figure out how i can add a 'related article' column onto my new design for this site.

right now, i have a table that holds details of every article, (i.e. keywords, html, title, desc, etc - each with it's own id), so how would i manage listing a related articles column for a given webpage?

What makes sense to me to do is:

Add a column to this table with certain keywords, and each article would have 5 or 6 keywords. Then for related articles, do a search of this column using the keywords you've set for the current article.

So for instance, having


So when you're at "Databases with PHP", you use it's keywords to scan the table again, specifically the "Keywords" column, searching for occurances. The more occurances, the more related it is.

Note I've ont thought of a goos SQL query to do this, comma deliminated lists are never great with scanning tables, so it needs improvement.

But as Microsofts latest campaign said for a short while, it just works.

Garth Farley

definitely something i don't want to do but that gave me an idea that i hadn't thot about!

Good Lord! Look at the state of my spelling

A terribly ashamed
Garth Farley

no, i was not talking about ur spelling tho i agree