Jump to content

Archived

This topic is now archived and is closed to further replies.

CanMan2004

Counting result

Recommended Posts

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

Share this post


Link to post
Share on other sites
SELECT * FROM usersscores ORDER BY score LIMIT 1,5;

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.