I'm trying to make a top 10 score list for a flash game.. http://www.kral.no/files/spill/toppti/
listing out the top 10 players goes fine... but if I want to list the players ranked 11-20, then I'm not sure how to do.. because, how do I know/tell which place they are at?? In my db, I've stored score, name and I have a autonumber field..
Right now I use this query:
SELECT ID, Name, Score FROM Topp10 ORDER BY Score DESC LIMIT $startNumber,10
($startNumber is set to 0 if not defined)
Can I use LIMIT when I'm trying to make this list..?
Well..shortly.. my problem is: how do I build the query and how do I set which place they are ranked at..?