tags:

views:

95

answers:

1

hey huys im counting my table with this code:

$county = mysql_query("SELECT COUNT(id) from table where type = 'application'");
$county = mysql_result($county, 0);
$applications = ''.$county.'';

this give me result like 1156563. but I want to see it like 1,156,563 with commas. how can i do this?

+7  A: 

number_format() should be what you need

If only one parameter is given, number will be formatted without decimals, but with a comma (",") between every group of thousands.

<?php
echo number_format(23124154);

//output: 23,124,154
Tom Haigh
thank you for your answer. that works!
Ronnie Chester Lynwood
why did I get a downvote?
Tom Haigh