RE: [PHP-DB] sorting
| From: | Adv. Systems Design | Date: | Tue, 02 Jan 2001 20:01:26 +0000 |
| Subject: | RE: [PHP-DB] sorting | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5523@lists.php.net to get a copy of this message | ||
Yes, it is a result in a mysql query...the field is
set up as a CHAR(2). What are the ramifications to the
current db of just changing the data type to INT or
FLOAT?
Thanks
--- Wesley Choate <wesleyc@daymarkgroup.com> wrote:
> I am assuming you are using a database of sometype
> to do this. If you are
> getting your results sorted like you are saying
> here, then this field is set
> up as an alpha field. To get the numbers to sort in
> numeric order the
> numbers must be in an integer or float or some other
> numeric type field.
>
> Hope that helps,
> Wesley Choate
>
> > -----Original Message-----
> > From: Adv. Systems Design
> [SMTP:asd_2000@yahoo.com]
> > Sent: Tuesday, January 02, 2001 10:22 AM
> > To: PHP List
> > Subject: [PHP-DB] sorting
> >
> > I have a situation where I am not getting the
> results
> > I want in a sort: I have lessons listed in grades
> > 1-12...well the ones that appear first are:
> > 10
> > 10
> > 1
> > 2
> > 2
> > 3
> > 4
> > I know this is the way a computer sorts, but can I
> get
> > it to sort like a human?
> >
> > TIA
> > Luis
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Photos - Share your holiday photos online!
> > http://photos.yahoo.com/
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail:
> php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail:
> php-db-help@lists.php.net
> > To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
> >
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/