Adding commas to large number strings

[gerkintrigg]

Hi everyone. I was wondering if there was some kind of stock command or stock script out there in cyber land that would allow me to break apart an SQL result string to add commas into a number.

For example:

instead of 123456789.00
it'd be: 123,456,789.00

I'd just like to make the (price) results look a little nicer for my site visitors. I've been playing with the explode & implode functions but they seem to be rather flakey. Probably just my syntax, but any help would be greatly appreciated.

[ToonMariner]

[a href=\"http://uk.php.net/manual/hk/function.number-format.php\" target=\"_blank\"]number format[/a]