Counting result

[CanMan2004]

Hi all

I have a simple game which is storing users details who play in, in a sql database, I also store the score that the user has got from paying the game.

The query I use to insert the data from the game to the sql database is

[code]$query = "INSERT INTO usersscores (fullname, email, score) VALUES ('$fullname', '$email', '$score');";
mysql_query($query);[/code]

What I want to do, is to run a query after the insert query shown above, which will show the user what score position they are. For example, if the database had 4 rows and looked like

23.23
34.54
45.32
65.22

and the users score was 29.87, then the query would run and return them as the 2nd highest score, again, if there score was 90.43, it would return as the 5th highest scorer.

Is this possible?

Thanks in advance for any help

Ed

My query is

[ober]

SELECT * FROM usersscores ORDER BY score LIMIT 1,5;

That would list them in order (1-5).

[Orio]

SELECT COUNT(*) FROM usersscore WHERE score<'$score'

This will count how many people have a score that is lower (better) than $score.
If you want to output the rank, add 1 to the result.

Orio.

[CanMan2004]

Thank you