
March 14th, 2004, 04:52 PM
|
|
|
|
Join Date: Apr 2007
Location: Long Island, NY USA
Posts: 24
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Currency into MySql
I'm in the process of building a Web Based club member database using PHP and MySql and most of the fields are simple text fields no problem.
I've come up to a sumble here. The club collects dues once a year and allows them to be paid in 4 quartly installments. I want to put in the amount of dues received to date, but I want to put them in NOT as text so I can do some math on the amount and calculate how much is owed. When I try and set the MySql data fields to INT it rounds the numbers to the nearest whole number if I set it to FLOAT it only give me one decimal place. Is there a way to put currency type data into MySql such as 10.50 and have it retrieved as 10.50 ???
What field type should be specified?
Thank you
Have a great day
-Jim
|