SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Mysql Query help
-
Mar 21, 2002, 13:03 #1
- Join Date
- Feb 2002
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
-
Mar 24, 2002, 09:16 #2
Can you post your table structures please?
SeanHarry Potter
-- You lived inside my world so softly
-- Protected only by the kindness of your nature
-
Mar 30, 2002, 17:09 #3
- Join Date
- Feb 2002
- Posts
- 4
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
Bookmarks