Someone else might be able to provide a SQL query for formatting with commas, but otherwise just let PHP do all your formatting.

PHP's number_format() function is probably your best bet. You might want to look at PHP's money_format() function also, since it might save you some time depending on what you're doing.

Wes


On Jul 16, 2004, at 8:04 PM, Braulio Lumbreras wrote:

Hello everyone,

I have a table with a column for real estate property listing values. The
column is set up as float(8,2). How do I go about setting up so that the
display on the web page includes a comma ? I get $155000.00 but would like
to see $155,000.00. You may go here to view the results,
http://swishermartinrealty.com/residentialhouseforsalelistings.php.


Any help will be greatly apreciated.

Thanks in advance, Braulio.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to