User's Rank Query..! 1

[triquad]

I have made a flash game that has a ranking system which allows the players to know the top 10 users ranked by score. That works fine but I'm trying to figure out a query that allows the player to know his own ranking if he's not listed in the top 10 players.

The query I use for ranking the top 10 is:

mysql_query ( "SELECT * FROM 'myscore' ORDER BY score DESC")

Any ideas ?!

 

[r937]

all you have to do to get a player's ranking is to count the number of players with a higher score than his, and add 1

by the way, that couldn't be your actual query, because you can't write a SELECT statement to pull rows from a string

SELECT * FROM [red]'myscore'[/red] ORDER BY score DESC

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon