[RESOLVED] table field type and numbers?

[v3nt]

hey guys! I'm trying to order some results by the price of the item but its doing it
1,11,2,3,36 instead of 1,2,3,11,36.

How can i get it to orders iteself to the true value? and what should the field type be for numbers? At the mo' its varchar!

Many thanks.

D.

[laserlight]

You should have it as say, INT instead. Since it is VARCHAR, it is sorting alphabetically.

[v3nt]

many thanks!