Sorting Numbers?

[Anon]

Hello,

I am trying to make a script that retrives information with different numbers from mysql. I need mysql to sort the numbers from largest to smallest. I tried Accending and Deccending and they dont work, for instance....

11
123
796

it sorts alphabeticly not by size, I need it to do this...

796
123
11

any help is appriciated!

[crusty_php]

Did you set the type as int. If so I would be interested to see your select statement.

[sarahk]

I suspect that the field which stores the numbers is actually a varchar and that is why the sort is based upon alpha rules, not numeric rules.

You can
change the underlying table
select the value of the field and sort by the new field
* sort once you are back in php

the following link points to a javascript sorting example but wouldn't be hard to convert:
www.npac.syr.edu/projects/tutorials/JavaScript/examples/advanced/

there are some other excellent versions out there so go hunting.