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

RE: [PHP] MySQL: Order by

John Taylor-Johnston mailto:[EMAIL PROTECTED] 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

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