adding places depending on the rating score

[imatus]

Hello again everybody :)

I have:

Player | Rating
----------------
player1 1060
player2 1020
player3 980
...
playerN 640

The data is being sorted by rating DESC.
Now I'd like to add 'Place': 1st for the highest rating etc, like:

# | Player | Rating
-------------------
1 player1 1060
2 player2 1020
3 player3 980
...
n playerN 640

but I cannot figure out how to do so :confused:

Please, drop me a hint!

Thank you in advance,
Have a wonderful day :)

[Magic_Clock]

Yes, yes thats nice.

[Kid Charming]

There isn't really a good way to do this in your query; you need to set that up in your display script.