Re: ordering a query

Just to expand slightly on this answer... think back to days at school, you order works as so aardvark, abbey, accoustic, ie you compare rightmost letters, if they match then compare the next letter along until you find a difference... this is what your sort is doing. It doesn't think 1 and 10 are the same, it compares the first digit, sees they are the same and postitions based on the second digit. As george correctly says changing the column type to INT will make sure the RDBMS orders them numerically rather than alphabetically Tom, a rambler ----- Original Message ----- From: "George Pitcher" <fmdev@yahoo.co.uk> To: <nate@1feehosting.com> Cc: <php-general@lists.php.net> Sent: Friday, September 07, 2001 9:00 AM Subject: Re: [PHP] ordering a query > It is simply ordering them as type data rather than as type integer. Change > your data type in the db. > > George, a newbie > ----- Original Message ----- > From: <nate@1feehosting.com> > To: <php-general@lists.php.net> > Sent: Friday, September 07, 2001 9:16 AM > Subject: [PHP] ordering a query > > > Me again :) > > I have a query that orders by id#, the problem is I have 17 items and I get > an output like so: 1,10,11,12,13,14,15,16,17,2,3,4,5,6,7,8,9 > > So it thinks 1 and 10 are the same, and it thinks 11 is less than 2 and so > on and so forth. Remedy please? (I'd rather not rename the items 01, 02, 03, > 04, etc.) > > Thanks again. > > Nate > > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >