I can get this to work just fine:
<?php
$number = 23999.39;
print "$";
print number_format($number, 2);
?>
Comes out $23,999.39
I'd like use the number_format() thingie on an array returned from a
mysql_query.
My current program snippet looks like:
$res = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS
cost FROM a05
GROUP BY org ORDER BY cost DESC",$dbh);
if (!$res) {
echo mysql_errno().": ". mysql_error ()."";
return 0;
}
print "<table border=1>";
while ($thearray = mysql_fetch_array($res)) {
printf("<tr><td> {$thearray[org]} </td>
<td align=right> {$thearray["COUNT(*)"]} </td>
<td align=right> $ {$thearray[cost]} </td></tr>");
}
print "</table>";
and works fine -- see <http://ibbmonitor.com/sked_1.php>, 3rd block
of stuff down.
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
I get
$ number_format(7842554.24, 2)
in the cell where I would expect to get
$ 7,842,554.24
Any idea what I'm doing wrong?
Clearly, I don't understand arrays very well.
Thanks VERY much for any help on this.
bw
---
Bill Whitacre
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
