list ordering

[ceemac]

I have a list of numbers in a mysql database. and when i pull it in to a php / html page i use the ORDER BY <<variable>> in the sql.

The only problem is that it comes in:

104
11
116
117
120
14

and so on. Can anyone please tell me how i can drag the information in from the database so that it displays in the correct order eg.:
11
14
104
116
117
120

please

Mark

[barand]

It looks as though the field is defined as a character field and not a numeric one.

If only whole numbers are stored, redefine as int.

[ceemac]

Thanks but unfortunately some of them are numbered as daft things like:
X12 or 104A

so it has to as a char

Mark

[barand]

The other option, then, is to store them in the database so that they are space-filled to the left instead of the right.

[ceemac]

yeah thanks, i was thinking of that, but the numbers have a very specific reference outside of my control so i can't. I'll have to think something up.

Mark

[barand]

How about reading your data into an array and then sorting the array with [man]usort[/man] and a custom sort function?