[rake]

Originally Posted by cinq

Problem Number 1

I would like a similar articles feature as part of this hack.
This means that, when viewing an article, at the bottom of the page, there should list the titles ( with links of course ) of articles which have similar content to what you are currently reading.

There are a couple of ways to implement this.
These are some of the ways I thought of :


- When adding/editting an article in the AdminCP, you manually select all related articles via a multiple dropdown list. However, this presents a problem. Going through a long list of articles just to select a couple of related ones is not easy.

- Let the system auto search for related articles.

1. use the title of the current article you are reading to provide the search keywords to search the title and contents of all other articles in the database. A problem with this is that common words in the current article ( eg. of, in etc. ) get searched too and may turn up too many irrelevant results.
2. enter keywords when adding/editting articles, and these keywords would be used as the search keywords to search the title and contents of all other articles in the database.

Are there any other suggestions as to how this feature can be implemented ?

For mysql 3 users: Research the LIKE syntax and find a way to implement it (for example: split thread title into individual words, filter out words that consist of less than 4 characters, then loop through the remaining words and make a list of conditions: OR title LIKE '%$word%' )

For mysql 4 users: Research the MATCH ... AGAINST syntax and you're all set.

And, if you really want to take it to the next level, there was a function that could produce equally sounding words, so you could even search for miswritten words. How cool is that? You should look that up, i forgot it's name..