Problem Sorting By Price

mysql sort price php problem

[matthewamzn]

I have a mysql database and I'm using php to display the results in a table on my website. I currently have it set so the results are sorted by the price field. But it doesn't seem to sort it by the value of the products. For example some of the results on my page give:
$14.95
$19.99
$24.98
$32.95
$8.85
$9.71

The price field is set to varchar(255). I'm thinking maybe I should change the type of field, but I'm not sure to what.

[matthewamzn]

nevermind, i had to choose a better field type

[yktan]

Yeap, in your case it's better to define it as a numeric field

[coopster]

I agree, and MySQL itself recommends type DECIMAL. A related discusssion:

SQL problem - 'order by' with numbers [webmasterworld.com]