Add static numbering to table

sbarnett

Hi,

I have a table of players in a game, which is initially sorted by their name.
Each player has a score, and if the user clicks on that column, then the table is reordered by the players' scores.

However, one of the crucial things for this game is who is in the top 10 players, based on their score.

So is there a way of having a column on the table which contains a number which will indicate the player's position without being reordered along with everything else when a user clicks on the "score" column?

For instance, initially a table might look like this:-

# Name Score
1 Andy 2
2 Bob 5
3 Chris 7
4 Dave 1

but when the Score column is clicked, it will look like this:-

# Name Score
1 Chris 7
2 Bob 5
3 Andy 2
4 Dave 1

Any ideas?