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 -----
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.


Do You Yahoo!?
Get your free address at

PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to