Assuming you have the variable member_id (for the member in question)...
Get the score for that member and store it to $score...
"SELECT score FROM members WHERE id=$member_id"
Then to determine rank, just do this...
SELECT COUNT(*)+1 as rank FROM members WHERE SCORE>$score;
-Jason Garber
IonZoft.com
At 08:47 PM 12/8/2001 +, Andrew Brampton wrote:
>Hi,
>This isn't a php question, more of a SQL question, but I don't know any
>where better to send it, and I guess its trival enough for someone here to
>answer.
>
>Anyway, I have a list of members each with a score field. How can I say
>that Member 3 is ranked 10 out of 100 members for example.
>
>Here is the layout of the members table:
>ID, Name, Score
>
>I can get the total count of members in the table, but I don't know how to
>determine what rank they are, unless I return all the rows in the table
>(sorted), and cycle through them until I find the member I want, counting
>how many people are above him... This method would work, but would be slow
>(and wastful), is there a better way to determine his position with a SQL
>Query?
>
>Thanks in advance
>Andrew
>
>P.S
>If it matters I'm using MySQL & PHP 4.0.6 on WinXP under Apache 1.3.22
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]