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 field type that works for this, but also will sort properly? I tried using VARCHAR, and the display was right, but when I sorted the results by price, 1,200,000 appreared before 230,900.
Any ideas? Natan Shar -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
