How to list the relevant articles

[Mushroom]

I intend to make a article manage system.
Are there any efficient way to find out the relevant articles of an article?
But I don't want to see that some keywords are given to the system when the editor edits the article,because the keywords are not easy to control .

[intenz]

You COULD add a "relevant" field into the database.

0 = non relevant
1 = relevant

Then just...

$query = mysql_query( "SELECT * FROM articles WHERE relevant = 1 ORDER BY id DESC" );

Good luck.

[Mushroom]

I want the system to tell if the two articles are relevant automatically,but not to define them.

thanks.