RE: [PHP-DB] sorting

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@yahoo.com] 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@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/ -- 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