[Resolved] Using the mySQL ORDER BY function to sort numbers

[AlwynVD]

Hi,

When I use the ORDER BY function to sort numbers, for instance 7, 10, 25, it will produce 10, 25, 7. So is there a way to sort these numbers the right way, and not the alphabetical way? And if this isn't possible, how do I use PHP to delete a zero at the beginning of a number (so I can just go ahead and use 07 in the database instead of 7).

TIA,
Alwyn

P.S. I was a bit hesistant to post a mySQL question on a PHP forum, should I take this elsewhere?

[lanjoky]

What type of field is the Field that you are ordering by? if it is int or some numerical type then it should work the way you want it to ... if its varchar or some text type field it will sort alphabetically...

HTH

[pete_bisby]

The only way you can do this is to use one of the rounding functions within the MySQL query. For example:

SELECT * FROM Numbers ORDER BY CEILING(textField)

will sort the text field containing your number as if it was a number field.

But I'd strongly suggest to change the field type to numeric.

[AlwynVD]

Ah, I still had them set to varchar, and changing it to INT worked like a charm. Thanks!