Why the "ORDER BY price" is so bad ??

[ovisopa]

Hello ppl,

I have this urgent question bout the "ORDER BY anything". Why if I have the numbers:10, 11,12,13,104,120 I recive this result :
10
104
11
12
120
..
????

Can somebody give me a FAST help??

10x

see ya

[rw22]

Make sure the column you order by is set as an integer !!

[ovisopa]

10x for help, that was my mistake when I made that table I made all filds text tipe except the id column, anyway now it's working fine.

10x again.

Bye