Hi,
I have a table in my (mysql) database with a prices field (set as DOUBLE).
When I retrieve the prices from the database and display them, some of the prices are 98.4 or 73.8. The client wants these particular prices to be displayed 94.80 or 73.80.
How do I add the 0 to the end of a price that might be 73.8. Bear in mind I also have some prices that come out as 65.45. So I would have to determine if the price has one or two values after the decimal.
Cheers Bruce
