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: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
