[Loinal]

Fixed

[Loinal]

Any help?

[Mic_H]

It is supposed to work.. Maybe the first one registered has the best score/money?

[Yousha]

Its because you are just selecting ONE (limit 1) and first record(by default)...
So I think it must be:

Код:

SELECT Username, Money FROM players GROUP BY Money DESC LIMIT 1;

or

Код:

SELECT Username, Money FROM players ORDER BY Money DESC LIMIT 1;

[Loinal]

Quote:

Originally Posted by Yousha Its because you are just selecting ONE (limit 1) and first record(by default)... So I think it must be: Код: SELECT Username, Money FROM players GROUP BY Money DESC LIMIT 1; Should i use group? or Код: SELECT Username, Money FROM players ORDER BY Money DESC LIMIT 1;

Should i use group