Re: [PHP] mysql ORDER BY problem

2006-06-18 Thread Rob W.
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

2006-06-18 Thread Rob W.
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 ...