So if there were 100 people playing and I was position 42,
I'd want to select from the row, ordering by score,
positions 38, 39, 40, 41, 42, 43, 44, 45, 46, 47 etc...
Thoughts?
sure, thoughts
how do you know where a certain user ranks? by comparing his score to the
every other user's score
correct?
this can be achieved with SQL, but it's convoluted
(it's actually real easy with windowing functions, by mysql doesn't support
those)
since you are talking about 100 users, my advice is to sort them by score
and read them all into a php array, then pick out the selected user and the
5 on either side
it's a lot easier that way, yes?
rudy
http://r937.com/
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
