Re: [PHP] mysql ORDER BY problem

Yeah, I got this problem fixed. The datbase was listed under [chr] instead of [integer]. Thanks for the help though. - Original Message - From: Xavier Casto To: Rob W. Cc: php-general@lists.php.net Sent: Sunday, June 18, 2006 7:30 PM Subject: Re: [PHP] mysql ORDER BY

[PHP] mysql ORDER BY problem

Ok, here's what i got in my mysql db. I got a table listed with numbers as follows 1 2 3 4 5 6 7 10 11 12 13 14 15 16 17 18 19 20 21 22 25 These numbers I can display fine. I'm using .. $query="SELECT * FROM db ORDER BY numbers ASC"; Right now it displays it as 1 10 11 12 . 2 22 23 25 ...

RE: [PHP] MySQL: Order by

Thanks all. That solved the problem. I should have realised it. Still learning ... :) -- John Taylor-Johnston http://compcanlit.ca/ > Sounds like your 'number' column is not actually a number but a string. > Change it to type INT and that should fix it. > Chris. -- PHP General Mailing List (h

RE: [PHP] MySQL: Order by

John Taylor-Johnston 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 a

[PHP] MySQL: Order by

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