PHP - Display Players Actual Postion In Rankings Ladder e.g 1, 2, 5 etc

[ArmoVanBuuren]

I am making a squash ranking website and I would like to find out peoples position in the rankings i.e 1, 4, 10 etc. I currently have a table (playerRankings) which contains playerRankingsID, pRankingsScore, pPrevRankingScore. In pRankingsScore is the players points score and I have a query that sorts by this field name so the person with the most points is top of the league.

How would I go about implementing this, any help would be greatly appreciated.

Many Thanks

Leon

 

[ArmoVanBuuren]

Works a treat DJ Jestar, just needed to change the sorting from ASC to DESC as it was putting the lowest ranked players at the top.


Cheers matey!