Creating a hit list

[ligraci]

Hi to all!

I have to create a hit list using mysql and php code starting from a table in MYSQL like this:

PLAYER |POINTS

player1 | 1000
player2 | 5000
player3 | 3000
player4 | 2000
...

I have to sort the records and to extract only 7 out of some thousand of them starting from the rank of one player. I mean that if a player is at rank 4, I need also the players in position 1,2,3,5,6,7.

Have you any idea about the right way to do?

Thank you in advance for your help!
Danielli