I believe I did this one time without changing the database schema; simply by just putting the type in the ORDER BY clause.
Something like ORDER BY BINARY numbers ASC or maybe ORDER BY CAST(numbers AS BINARY) ASC Regards, Dwight > -----Original Message----- > From: J. Alejandro Ceballos Z. -JOAL- > [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 18, 2006 7:01 PM > To: php-db@lists.php.net > Cc: [EMAIL PROTECTED] > Subject: [PHP-DB] re: mysql ORDER BY problems > > are they defined as integer or varchars (string)? > > try > a) exchange field definition varchar / integer > b) order by length(number) and later by number > > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
