How to display currency with commas

[Rio]

Hello all,

I have a question about how to display currency with commas.

One of the columns is in type"decimal" at the moment. For example, £12,345,678.00 is inserted (only the number bit, without £ sign) as 12345678.00 in to the database and therefore the output is £ 12345678.00.

Can I re-format the output in PHP so that the final output on the Web page will be £ 12,345,678.00?

I think I have to stick to "decimal" type as I have to caluculate the sume of the column.

Rio

[firepages]

number_format() gives you a few options

www.php.net/number_format

<?
$num=12345678.00;
echo number_format($num,2,'.',',');
?>

- just read the last bit of your post you will need to keep a copy of your $num as number_format() converts it into a string.

[Michel V]

http://www.php.net/localeconv

Hope this helps


Edit: ah yes, number_format() is nice

[Rio]

Cool! I tried number_format() and it works just fine.

Thanks for your help, guys.