Re: diplaying rows in numerical order with mysql
| From: | Sheila Myers | Date: | Mon, 15 Oct 2001 22:59:34 +0000 |
| Subject: | Re: diplaying rows in numerical order with mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-71153@lists.php.net to get a copy of this message | ||
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