RE: [PHP] MySQL: Order by
| From: | Chris W. Parker | Date: | Thu, 05 Feb 2004 16:54:43 +0000 |
| Subject: | RE: [PHP] MySQL: Order by | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-176913@lists.php.net to get a copy of this message | ||
John Taylor-Johnston <mailto:taylorjo@collegesherbrooke.qc.ca>
on Wednesday, February 04, 2004 9:48 PM said:
> When I order by number, it echoes 1,2,3,4,5,6,7,8,9,10 and hten jumps
> to 100...199 before it comes back to 11-19. Any way of ordering that
> differently?
Sounds like your 'number' column is not actually a number but a string.
Change it to type INT and that should fix it.
Chris.