Manauls RULE! check em out. http://www.mysql.com/doc/en/Numeric_types.html the FIRST example in the manual is exactly what you need. "shaun" <shaun@mania.p To: php-db@lists.php.net lus.com> cc: Subject: Monetary field in MySQL 05/23/2003 10:47 AM Hi, how can I have a field in MySQL that represents a monetary value i.e. it always has 2 zeros after the decimal point? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
