Jump to content


Photo

Adding commas to large number strings


  • Please log in to reply
1 reply to this topic

#1 gerkintrigg

gerkintrigg
  • Members
  • PipPipPip
  • Magician
  • 828 posts
  • LocationBristol, UK
  • Age:37

Posted 11 April 2006 - 10:09 AM

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.
Neil Trigger - http://www.ghostlypublishing.co.uk - Ghostly Publishing - Children's Fantasy Books

#2 ToonMariner

ToonMariner
  • Members
  • PipPipPip
  • Advanced Member
  • 3,342 posts
  • LocationNewcastle upon Tyne, UK

Posted 11 April 2006 - 10:15 AM

[a href=\"http://uk.php.net/manual/hk/function.number-format.php\" target=\"_blank\"]number format[/a]
follow me on twitter @PHPsycho




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users