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
$query = "INSERT INTO usersscores (fullname, email, score) VALUES ('$fullname', '$email', '$score');"; mysql_query($query);
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
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
My query is