 |
 |
 |
 |
|
|
Date: 10/15/01
- Next message: Justin Brown: "[PHP] phpclasses.upperdesign.com down?"
- Previous message: Matthew Loff: "RE: [PHP] run through array with list only once?"
- In reply to: brett: "[PHP] diplaying rows in numerical order with mysql"
- Next in thread: Ralph Guzman: "RE: [PHP] diplaying rows in numerical order with mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I'd guess you have your row number field defined as text rather than
number. MySQL is sorting the numbers in 'alphabetical' rather than
numerical order: first the 1st character in each 'word', then the
second, and so on.
HTH,
Sheila
Brett wrote:
>
> I have a table for which I want to display rows from my database. The rows
> should be ordered 1,2,3...etc. Instead the order by clause displays
> 1,10,11,12,13,14,2,3,4...etc.
>
> Is their a way to display this in the normal human order?
>
> Brett
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe <email protected> For additional commands, e-mail: php-general-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Justin Brown: "[PHP] phpclasses.upperdesign.com down?"
- Previous message: Matthew Loff: "RE: [PHP] run through array with list only once?"
- In reply to: brett: "[PHP] diplaying rows in numerical order with mysql"
- Next in thread: Ralph Guzman: "RE: [PHP] diplaying rows in numerical order with mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]