How to i find the highest Number of all users on Database

Discussion in 'PHP' started by CuBz, Oct 9, 2007.

0
  1. #1
    I have a game and i want to find out who has the most money as someone has cheated, but when i go onto the database and put the money in descending order, it shows all numbers that start with 9 but not the highest number on there.

    Is there a way i could show highest number on there?

    Thanks
     
    CuBz, Oct 9, 2007 IP
  2. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    #2
    is the money coulmn defined in number format or not?
     
    kishore415, Oct 9, 2007 IP
  3. matthewrobertbell

    matthewrobertbell Peon

    Messages:
    781
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #3
    SELECT money FROM members ORDER BY money DESC LIMIT 1 ?
     
    matthewrobertbell, Oct 9, 2007 IP
  4. foreststone

    foreststone Peon

    Messages:
    1,355
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Select MAX( money ) from members :D
     
    foreststone, Oct 9, 2007 IP