sorting mysql rows

[easethan]

Upon selecting several rows, is it possible to order them by a feild containing only numeric values? If you set it to ORDER BY price, 15 would come after 100 because 5 comes after 0. Thanks in advance.

[weekender]

sounds like you have the data types wrong.

15 only comes after 100 if you're sorting alphabetically, as would happen if the sort field is a text (or text-based) field.

If the field is of number type (int, long, double, float etc) it will sort numerically (ie 15 then 100)

ads

[easethan]

you're absolutely right. I forgot that I was using varchar because the feild holds money values and needs the decimal to seperate dollars and cents. This would take a lot of programming(there are a lot of scripts that use this database) but I guess I could change the feild into two int feilds for dollars and cents. Is there any other way to do it?

[superwormy]

Use a FLOAT or DECIMAL field... DO NOT USE CHAR, VARCHAR, OR INT fields for storing floating point values ( ie, money )