A
Anonymous
Guest
Once you know the score of the entry you can determine its "rank" by selecting all records wich have a better score.
The number of records that comply with that query are in front of that score.
example:
rank..score
1..10
2..8
3..5
3..5
3..5
6..3
7..2
7..2
When you want to know the position of score "5", you find out that there are 2 records in front of that, 2 + 1 = 3 -> position 3.
I think you can build the query yourself.
Greetz Daan
The number of records that comply with that query are in front of that score.
example:
rank..score
1..10
2..8
3..5
3..5
3..5
6..3
7..2
7..2
When you want to know the position of score "5", you find out that there are 2 records in front of that, 2 + 1 = 3 -> position 3.
I think you can build the query yourself.
Greetz Daan