Related articles [CMS]

[SilverBoy]

Hi

I'm trying to implement new widget to display related articles to the current one which user read. my principle built on using "Tags" as a key to find best results.

The problem is that when I tried to write the algorithm for the widget code, I had bad feeling and I think it is not the right way to do this thing and if it works it will be hungry resources widget.

My algorithm works like this, first catch all tags the article has, then search on them on other articles, if the tag1 found in article1 then there is a new special field stored in the nodes DB with default value '0' will be '1'.

after that I will check articles for Tag2, and if article2 have it the new field will be '1', and if article1 has it too the value of the field will be '2', and so on for the rest of tags.

Then we will sort the articles regarding to 2 factors, 1 is the value of the new field (desc. sort) and 2 is the date and time of publishing date-time and select only articles which have been written before the time-date of publishing of the current article and order of the list will be desc to (to show near written articles first).

The result will show the most relevant articles and most near articles in the widget.

After completing the work the value of the new field will be reset to '0' again.

Any help to implement this widget?

Thanks in advance.