PHP/MySQL Beginner Needs Help

[JeffGSR]

When I add a number to my MySQL database with a comma say for example 34,000, I get only 34 when it is outputted into my web document. How do I get around this problem? I want to be able to add a number with a comma and then it to be outputted with a comma.

Any help is greatly appreciated.

Jeff

[mind21_98]

When I add a number to my MySQL database with a comma say for example 34,000, I get only 34 when it is outputted into my web document. How do I get around this problem? I want to be able to add a number with a comma and then it to be outputted with a comma.

Any help is greatly appreciated.

Jeff

You'll need to get rid of the comma first using PHP:

$number = preg_replace("/,/g", "", $number); 

then you can insert it into the DB. I'm not sure how you'd go about putting the comma back in though.

[Powerlord]

You can get the comma back when extracting from the DB by using the number_format() function.