RE: [PHP-DB] sorting

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 >