Math Datatypes for Currency
Posted 27 February 2006 - 12:28 PM
I am trying to build a small accounting system using php/mySQL. What datatypes should I use to store amounts, i.e. monetary values? Also, how can I format the amounts so that they are presented as €xx.yy and not €xx.y if the y value is 40 cents for example?
Posted 27 February 2006 - 12:55 PM
[a href=\"http://us2.php.net/money_format\" target=\"_blank\"]http://us2.php.net/money_format[/a]
and here for data types
[a href=\"http://www.htmlite.com/mysql003.php\" target=\"_blank\"]http://www.htmlite.com/mysql003.php[/a]
Hope it helps.
[br][br]The truely intelligent people are not those who create the dots; rather they are they ones with the ability to connect the dots into a coherent picture
all the brothers were valiant!
Posted 27 February 2006 - 01:10 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users