For a server Game... I have table Jewels:
rank,player_id, plscore.
I want to show the top 10 players sorted by their score, high to low, plus the current player score if the current player isn't in the top 10.
It can be my or your score if i/you are not in the top 10 currently.
The maximum number of Jewels which can be picked up is 70.
Example(desired):
__________________________________
rank | player_id | plscore
1 zorro007 70
2 trus 70
3 edvino 67
4 snow.boy 65
5 anida 61
6 nadal_raffo 58
7 syskowitz 43
8 misterProKill 27
9 katamadu134 22
10 ewrgreen89 16
. . .
. . .
94 CURRENT PLAYER 7
___________________________________
Image: http://postimg.org/image/3x8ktdjct/
SELECT rank, player_id, plscore
FROM table_name WHERE rank < 11
OR player_id = current_player_id
ORDER BY rank;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With