RE: [PHP] Small ORDER problem (mysql) :)
| From: | NCI/IMS) | Date: | Wed, 08 May 2002 19:53:12 +0000 |
| Subject: | RE: [PHP] Small ORDER problem (mysql) :) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-96645@lists.php.net to get a copy of this message | ||
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
-----Original Message-----
From: Hawk [mailto:hw2k@barrysworld.com]
Sent: Wednesday, May 08, 2002 3:49 PM
To: php-general@lists.php.net
Subject: [PHP] Small ORDER problem (mysql) :)
I have a scoreboard with results with one and two letters, the problem is
when I ORDER BY score ASC the scores are 12,3,6,9 in that order.. etc.. how
do I do to get them in 12,9,6,3 order?
Håkan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php