How can I add commas correctly to numbers? ie: 1000 -> 1,000
Or can SQL do that for you when inserting numbers as data? I've tried BIGINT and it doesn't add commas.
Read up on [man]number_format/man
That said, you probably should not store the data this way, only format it for output.
[man]number_format/man
However, keep in mind that '1,000' is not a number, it's a string. It will most likely give you errors if you try to use it as a number.
but
intval(str_replace(',','',$string));
is a number.
