Re: [PHP-WIN] mysql money field type?

2004-06-28 Thread Ross Honniball
This is a function I use. Modify as you wish. function Price($amount) { return ($amount) ? '$'.number_format($amount, 2, '.', ',') : '-'; } At 04:04 AM 28/06/2004, you wrote: I have created a database for a local real estate company, and I am having issues trying to display home prices with com

Re: [PHP-WIN] mysql money field type?

2004-06-28 Thread Larry E . Ullman
I have created a database for a local real estate company, and I am having issues trying to display home prices with commas. when you get into the hundreds of thousands of dollars, it is quite difficult to look at home prices without commas. I am using mySQL and PhpMyAdmin. Is there a mySQL f

[PHP-WIN] mysql money field type?

2004-06-28 Thread Natan Shar
I have created a database for a local real estate company, and I am having issues trying to display home prices with commas. when you get into the hundreds of thousands of dollars, it is quite difficult to look at home prices without commas. I am using mySQL and PhpMyAdmin. Is there a mySQL fiel