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.
Store the value as a number (integer) but then use a MySQL or PHP function (like PHP's number_format()) to format it with commas.
Larry