Re: ordering a query
| From: | George Pitcher | Date: | Fri, 07 Sep 2001 08:00:21 +0000 |
| Subject: | Re: ordering a query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-66356@lists.php.net to get a copy of this message | ||
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