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.