Newbie MySQL/PHP question re output formatting

[Bill Whitacre]

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
bw@stripped