Mysql Query help
I have a which holds scores and users for online games.
I search throughthe database and output the results in order of score descending.
I can also search for a specific user.
Does anyone know how to search for a specific user and dynamically show where they are in the league with the 5 people above and below them..
Any help much appriciated.
Can you post your table structures please?
This is basically it, (not at work so Cant say exactly)
Userid -> int
Points -> int(10)
Level -> int(5)
The other bits are basically irrelevant.
The SQL I use is
Select * from Game order by Points Asc.
Thanks in advance.