[thePurpleGiant]

Hey guys!! (excuse me if there are any ladies in the web dev forum, I don't think there is)

I have a slight problem. I am making a website for a real estate company - this is the first database site I have ever done.

In the price field, the database only wants numbers. Fair enough, I have set it to print a $ out the front of any price anyway.

But I need the comma's for the thousands! A house selling for $500,000 is much easier to read than $500000.

If I put a comma into the price field, it doesn't like it. I don't mind if the comma isn't in the database itself, but when it displays on the screen I really need it to put them in the right spots. Any ideas?

Sample here:
http://www.kenbucklandrealestate.com...erty.php?ID=30

(price is down the bottom)

Any suggestions at all are welcome! Using php and mysql at the moment.

[Arkham_c]

Originally posted by thePurpleGiant:
If I put a comma into the price field, it doesn't like it. I don't mind if the comma isn't in the database itself, but when it displays on the screen I really need it to put them in the right spots. Any ideas?

PHP will do this for you with a number formatter (number_format). Something like this:

[php]
$total=123456789.12345;
$total="$".number_format($total, 2,'.',',');
$total will be a string formated as '$123,456,789.12'
[/php]

Read here for more info:

http://www.php.net/manual/en/function.sprintf.php

[Wevah]

Yes; store it without, and put it in using PHP.

[thePurpleGiant]

Thank you!!!!

http://www.kenbucklandrealestate.com...erty.php?ID=38

^^My house^^ (with comma's - gotta ditch the decimal tho...)