Problem with mysql

[iJoe]

Hey,

On nexdana I want to display the most played games on nexdana, it all works code wise however, mysql thinks that 9 is a bigger number than 23

I tried adding 000 before all the numbers so it would read

00001
00010
00023
00009

and it would know that 23 is the largest number, however, when a person plays a game it's updating the database by 1 and removing the 0000 so i'm back to square one

does anyone know how I can resolve this issue?

Thanks and +rep to all decent replies

Joe

[BoyBetterKnow]

Is the column int ?

[iJoe]

Is now Thanks