From: "Susan Ator" <SAtor@npr.org> > If I have a field in mySQL consisting of a number with 8 digits a decimal > point and 4 more digits what is the field type it needs to be to sort it > numerically? > > I've tried decimal(8,4) but it converts everything to 99999999.9999. I've > also tried float but it doesn't sort numerically. All of the other integer > types cut off the decimal bit. > > Any help would be appreciated. What's this got to do with PHP? Read here: http://www.mysql.com/doc/en/Numeric_types.html ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
