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:buzon@xxxxxxxxxxxxxxxxxxxxxxx] > Sent: Sunday, June 18, 2006 7:01 PM > To: php-db@xxxxxxxxxxxxx > Cc: rob@xxxxxxxxxxxxxxx > Subject: 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
