Hi ya,
Any help with this problem anyone?
Have decided to include a top 10 chess league position table on my homepage. The league is sorted by the number of points a player has. 1st place the most points. This has been an easy task to do, using ORDER BY and LIMIT mysql commands.
Problem is I run into problems when 2 or more players have the same league points. I've decided that players will share the position when this happens, but mysql will only return the top 10. Obviously if 2 players have 10th position I need to extract 11 players from the database.
I could do this retrieving all players and sorting the list using PHP array. Quite easy, but is this the most efficent to go about it? Extra time retrieving rows from database I won't be using.
My questions I'm asking is; is it possible to retrieve the top 10 players with the highest score, but include more players if league points are the same.
Hope I've explain myself properly. To visually see my chess games league table may help solve this problem.
Any help most appricated.