Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] sorting From: Cal Evans (cal <email protected>)
Date: 01/02/01

IMHO,

Unless you have a reason for making that a Char(2) (i.e. you are going to be
using alphabetic characters in it) then I would change it to an int. If it's
only going to go to 12 then I'd make it a tinyint.

cal

-----Original Message-----
From: Adv. Systems Design [mailto:asd_2000 <email protected>]
Sent: Tuesday, January 02, 2001 2:01 PM
To: PHP List
Subject: RE: [PHP-DB] sorting

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 <email protected>> 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 <email protected>]
> > 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 <email protected>
> > For additional commands, e-mail:
> php-db-help <email protected>
> > To contact the list administrators, e-mail:
> php-list-admin <email protected>
> >

__________________________________________________
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>