[PHP-DB] mySQL field structure question
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 .. 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. Susan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mySQL field structure question
From: Susan Ator [EMAIL PROTECTED] 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 .. 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