Re: Commas Missing.

2004-07-18 Thread Braulio Lumbreras
Thanks, Matthew. It worked. Braulio. "Matthew McNicol" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I would suggest formatting the number at the presentation stage, once > the information is retrieved from the MySQL database. e.g. using PHP see: > http://www.php.net/manual

Re: Commas Missing.

2004-07-18 Thread Matthew McNicol
I would suggest formatting the number at the presentation stage, once the information is retrieved from the MySQL database. e.g. using PHP see: http://www.php.net/manual/en/function.number-format.php MySQL does not store numbers with a currency symbol or with the "thousands group" separator. B

Commas Missing.

2004-07-17 Thread Braulio Lumbreras
Hello everyone, I have a table with a column for real estate property values. The format of the column is float(8,2). When the results are presented on the web page I get $155000.00 versus $155,000.00. How do I go about getting the comma in the values. I am using a MySql table. Thanks in adva