SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql Query help

    I have a which holds scores and users for online games.

    I search throughthe database and output the results in order of score descending.

    I can also search for a specific user.

    Does anyone know how to search for a specific user and dynamically show where they are in the league with the 5 people above and below them..

    Any help much appriciated.

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you post your table structures please?

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is basically it, (not at work so Cant say exactly)

    Userid -> int
    Points -> int(10)
    Level -> int(5)

    The other bits are basically irrelevant.

    The SQL I use is

    Select * from Game order by Points Asc.

    Thanks in advance.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •