Ordering by Numbers

[Anon]

Hi all I wonder if you could help with a problem,

I have a few fields within my table but two of them are id and views (number of times a pohoto has been viewed). I would like a user to be able view the data sorted by either of these. I have the code up and running but while using 'ORDER BY id' the results come out wrong while I use 1, 2, ... 10 etc
They come out as
1
10
11
2

I realise I could use 00001, 00002 etc but is there a way to sort the results correctly still using the one digit single numbers?
Again views can be done by 0 views = 10000 etc and then echo views - 10000 but I would like to keep the single numbers,

Any Help would be greatly appreciated,

Danny Hill

[andreas]

Try making the field an int insted of char (or varchar)...

Andreas

[Anon]

what if the field HAS to be a char, like in the case of usernames?

user1
user10
user2
user20

How do we sort those logically?

TIA,
Jeff