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.
Braulio Lumbreras wrote:
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 advance, Braulio.
--
_________________ Matthew McNicol
yellowmarker.co.uk PHP / MySQL web development
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
