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/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]
