help me please

totalf1

I have a Managergame with a TOP 20 page

player 1 has 2000000 points
player 2 has 3000000 points
player 3 has 1500000 points
player 4 has 9000000 points

and I use the next QUERY

$query="SELECT * FROM pama_members ORDER BY totaalver DESC";

The TOP 20 page comes out with the next results

first place = player 3
second place = player 1
thrid place = player 2
fourth place = player 4

but the results must be

first place = player 4
second place = player 2
thrid place = player 1
fourth place = player 3

what must i do now

I now my english is not ferrygood but i'm Dutch

greets TOTAL F1

eriksmoen

try

ORDER BY totaalver ASC

totalf1

this is what i see now with
$query="SELECT * FROM pama_members order by totaalver ASC ";

104000

2176501

308400

383200

this is what is see with
$query="SELECT * FROM pama_members order by totaalver DESC ";

383200

308400

2176501

104000

but i must see

2176501

383200
308400

104000

eriksmoen

i'm assuming that you are saving them as strings (varchar or something) in the database... try changing the field type to INT and the order by should work better for you...

totalf1

thanks it works

And thanks for the fast reply

you can see the database working on

Database of the managergame