order by problem?

[_SuperString]

[problem solved - i was able to change the datatype which solved the problem]

I've got a table and the rows have a values like:

65
393827
34
54
8

the data is stored as varchar....

currently if I use ORDER BY fieldname DESC I get something like:

34
393827
54
65
8

which is clearly not what I want..

What is the best way to write MySQL Queries to order these correctly? failing this any idea how to order a 3d array to solve this?

Is there a way to declare the field as int to have it ordered correctly?

cheers

[ShawnK]

If you have phpMyAdmin then just change the column type to INT. If you have to do your mySQL manually then use this query:

ALTER TABLE tablename MODIFY columnname INT NOT NULL

But if you don't have MySQL 3.22.16a then use this query:

ALTER TABLE tablename CHANGE columnname columnname INT NOT NULL

The only differance is that the older version requires you to put an old and new name. Even if they are the same.