RE: [PHP] Small ORDER problem (mysql) :)
| From: | NCI/IMS) | Date: | Wed, 08 May 2002 20:00:59 +0000 |
| Subject: | RE: [PHP] Small ORDER problem (mysql) :) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-96648@lists.php.net to get a copy of this message | ||
I don't know then - I've never run into that problem if they were already
numeric. You could try sorting in PHP - it might handle things the way you
want them to.
You might want to send this to the PHP-DB list if you don't hear from anyone
else on this list.
-Natalie
-----Original Message-----
From: hwk@barry [mailto:hw2k@barrysworld.com]
Sent: Wednesday, May 08, 2002 3:54 PM
To: Leotta, Natalie (NCI/IMS)
Subject: Re: [PHP] Small ORDER problem (mysql) :)
They are numbers, but that doesn't help, I've only solved it by using 03 06
09 12 and so on, but I dont want to use the 0, it looks ugly :)
Håkan
>>Can you make them numbers instead of characters in your database? If
>>not, then you could probably cast them after you query the db, put
>>them in arrays, and then sort.
>>
>>-Natalie