Thursday, March 09, 2006

Taking ranking to the next level

Thanks to Markus for coming to my quick rescue. Here's what I am trying to do and want to know what approaches would be most efficient.

After seeing the excellent solutions on Arjen's live journal, I started wondering about one thing: scaling the ranks to be within a specified range (1 to 10).

So the highest rank is always 10 and never 11 even if there are 1000 entries in the table.

Is this possible with MySQL? If so, what would be the best way to do it within MySQL (I'd prefer to do it within MySQL without help from a programming language).


No comments: