Professional Web Applications Themes

Anyone know how to return the position of a record in a table? - MySQL

Anyone know how to return the position of a record in a table? I'm building a highscore list and I want to be able to say what position a player is without having to check all the other players. Cheers, Ciarán...

Sponsored Links
  1. #1

    Default Anyone know how to return the position of a record in a table?

    Anyone know how to return the position of a record in a table? I'm
    building a highscore list and I want to be able to say what position a
    player is without having to check all the other players.
    Cheers,
    Ciarán

    Sponsored Links
    Ciaran Guest

  2. #2

    Default Re: Anyone know how to return the position of a record in a table?

    You could query the count of anything that is more than that player's
    score, I guess.

    Ciaran wrote: 

    --
    Willem Bogaerts

    Application smith
    Kratz B.V.
    http://www.kratz.nl/
    Willem Guest

  3. #3

    Default Re: Anyone know how to return the position of a record in a table?

    Good idea! Ha ha and I thought someone was gonng come back with some
    crazy long SQL statement!
    Cheers
    Willem

    Ciaran Guest

Similar Threads

  1. DIV position in Table
    By smillerd in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: August 15th, 08:40 PM
  2. Replies: 7
    Last Post: July 20th, 06:00 PM
  3. How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
    By keonglah in forum Coldfusion Database Access
    Replies: 6
    Last Post: June 13th, 02:53 AM
  4. field position when going to the next record
    By Asha in forum Microsoft Access
    Replies: 2
    Last Post: August 9th, 11:59 PM
  5. Return a Character String-position through a function
    By J. Darrington in forum Microsoft Access
    Replies: 2
    Last Post: July 17th, 02:24 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139