Cheers both.. Rudy, I took 100 out of a hat.. it's more likey to be 100,000 So I'll use Jure's suggestion for now...
Love this list!!! On 16/04/2008, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, using mysql 5 this query works: > Select * from t where > (Rank between (Select rank from t where user=id)-5 and (Select rank from t > where user=id)+5) > > But it is ugly and probably doesn't work on older mysql versions. Have fun, > Jure. > Sent via BlackBerry from Vodafone > > > > ____ • 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. > -- "The only people who don't make mistakes are those who don't do anything" Give a man a fish and he'll feed himself for a day. Give a man a religion and he'll starve to death praying for a fish. Anon `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz ____ � 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.