you can use a float type.
ALTER TABLE `blah` ADD `aMoneyField` FLOAT(6,2) DEFAULT "0.00"
Hope it helps =)
Rolf Brusletto http://www.phpExamples.net
shaun wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro* 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
