Mysql Query help

[neoblastuk]

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.

[seanf]

Can you post your table structures please?

Sean

[neoblastuk]

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.