MySQL: Order by
| From: | John Taylor-Johnston | Date: | Thu, 05 Feb 2004 05:47:45 +0000 |
| Subject: | MySQL: Order by | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-176866@lists.php.net to get a copy of this message | ||
This is probably a MySQL question, and maybe an easy question, but I'm here to learn <|:)
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?
$sql = 'SELECT * FROM '.$table.' ORDER BY number desc;';