Jump to content


Photo

Counting result


  • Please log in to reply
3 replies to this topic

#1 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 27 September 2006 - 04:45 PM

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

$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

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

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 27 September 2006 - 04:52 PM

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

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

Info: PHP Manual


#3 Orio

Orio
  • Staff Alumni
  • Advanced Member
  • 2,491 posts

Posted 27 September 2006 - 04:54 PM

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.
Think you're smarty?

(Gone until 20 to November)

#4 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 27 September 2006 - 05:04 PM

Thank you




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users