Re: Currency Problem

2002-08-21 Thread Dave Reinhardt
this is a php question, try: http://www.php.net/manual/en/function.number-format.php > Hi, > > I just want to know if mysql can set the output of a certain currency to > this pattern : > > $1,500.00 > > If I use a comma on a certain amount then I add it up to another amount with > a comma I ge

Currency Problem

2002-08-21 Thread delz
Hi, I just want to know if mysql can set the output of a certain currency to this pattern : $1,500.00 If I use a comma on a certain amount then I add it up to another amount with a comma I get the wrong answer. I'm using php & mysql by the way. Any hints on this one? Regards, Delz