DOUBLE data type and use for Currency

[siwis]

I have a products table which has three price fieds, all with their data type set to DOUBLE.

The problem I need a quick solution to is how to prevent, or to rectify once the data is pulled back, the price field from losing it's trailing 0, eg if the price is £29.90 it writes back to screen as 29.9

Does anyone have a quick function that will replace the trailing 0 if it is missing, just a quick pointer as to how I can achieve it. prices which a round pounds etc aren't a problem, just those with a simgle 0 at the end.

[Anon]

This example is exactly what you describe:

http://www.phpbuilder.com/manual/function.sprintf.php

[siwis]

Thanks, as it happens, I'd already found my solution anyway!

$prod_price = number_format($prod_price, 2, '.', '');