Hi all... I've been asked to put together a league table thingy for a client. What they want is to show the current users position, relative to the whole board.
So, If I'm ranked 356 for example, on my leauge table view, I wanna see me highlighted inthe middle and Ranks 350 - 355 above me, and then 357 - 361 below me. each user in the DB has a score tally, that increments as the user plays the game. (It's a quiz thing). So eg: SELECT userName, score FROM resultsTable WHERE userName = '$myUserName' (and 5 above/below too!) ORDER BY score DESC LIMIT 11 Is this easy, google is making my Monday morning hard... :-( Tris... ____ � 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: [email protected] 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.
