Hi there folks,
I'm creating a news creation script (PHP/MySQL) and need to have a "Related Stories" box on each page.
The way I'm going about this is to search is to remove all common words (and, the, that etc) from the headline and search the DB for instances of the remaining words. Then the script lists the instances and allows the poster to select which stories are the most relevant.
How would I go about removing the common words and searching for the remaining words without using a million SELECT statements?
Can anyone think of a better way of doing this that would produce semi-decent results? I'd love to hear it!
Thanks in advance,