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 +0000, 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]
