PDA

View Full Version : Problem with mysql



iJoe
12-08-2009, 11:42 PM
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
13-08-2009, 07:54 AM
Is the column int ?

iJoe
13-08-2009, 04:30 PM
Is now :P Thanks

Want to hide these adverts? Register an account for free!