problem in sorting

[scorpioy]

I have a table 'PHONE' with column 'price'. I declared it as varchar type. When I select the table sorted by price. It only follows the order as string. For example, when there are price 20, 100, 35. It displays the result as 100, 20, 35, which is incorrect. I want it to show as 20, 35, 100.

Does someone know a easy to correct it? (I prefer not to change the data type in the table)

Thanks.

[chyan]

you must change your data type in order to let Mysql sort it correctly

but if you dont want to change your data type , there is one way,
you can using php to fetch your dataa nd compare them each other so you will get the data from small to bigger number