commas in numbers

[Tandem]

Ok, i'm mysql_query()'ing and then mysql_result()'ing, so that i can print values from my database onto my site. One of these is an integer. I want there to be commas in the integer if possible. For example: instead of 1000000 - it would be 1,000,000.

Is this possible? if so how?

Thanks in advance.

-Tandem

[willfitch]

There are a couple of ways to do this:

Using SQL
SELECT FORMAT(field_name)
or PHP:
number_format($int)

[Tandem]

Awesome, I couldn't have asked for btter help!

Thankyou.