.00 numbers on numbers from a MySQL DB via PHP

[knippysing]

In the code below, I'm trying to get it so that the numbers in "LaborHours, LabCostPerHr, etc" are #.00 instead of #. Or so they are #.50 instead of #.5

I know that the code "%5.2f" within a printf will work but I can only get it to work on a single item, not an array.

Any help would be great! Thanks

 <?php
require './connect.php';
$var = $_GET['var'];
$sqlquery1 = "SELECT SalesCrosstab.Invoice, Sales.ShipCSZ, SalesCrosstab.DueDate, SalesCrosstab.LaborHours, SalesCrosstab.LabCostPerHr, SalesCrosstab.TotalLabor, SalesCrosstab.MatCosts, SalesCrosstab.TaxCost, SalesCrosstab.AmtCharge, SalesCrosstab.EquipID, SalesCrosstab.EquipName, Customer.LastName
FROM Customer INNER JOIN (SalesCrosstab INNER JOIN Sales ON SalesCrosstab.Invoice = Sales.Invoice) ON Customer.CustNo = Sales.CustNo
WHERE (((SalesCrosstab.Invoice) Like '0%') AND ((SalesCrosstab.EquipID) Like 'PA%') AND ((Sales.CustNo) Like '00032%'))
ORDER BY $var";
$result = mysql_query($sqlquery1) or die (mysql_error());
$num=mysql_num_rows($result);
$i=0;

while ($i < $num) {
$a=mysql_result($result,$i,"Invoice");
$b=mysql_result($result,$i,"LastName");
$c=mysql_result($result,$i,"DueDate");
$d=mysql_result($result,$i,"LaborHours");
$e=mysql_result($result,$i,"LabCostPerHr");
$f=mysql_result($result,$i,"TotalLabor");
$g=mysql_result($result,$i,"MatCosts");
$h=mysql_result($result,$i,"TaxCost");
$j=mysql_result($result,$i,"AmtCharge");
$k=mysql_result($result,$i,"EquipID");
$l=mysql_result($result,$i,"EquipName");
// alternate #8F8F8F with #FFFFFF
print ($i % 2)? "<tr bgcolor=\"F0F0F0\">" : "<tr bgcolor=\"FFFFFF\">";

print "<td align=left><font size=2 px><a href=..\invoices\invoice.php?var=$a>$a</a></font></td>";
print "<td align=left><font size=2 px>$b</font></td>";
print "<td align=left><font size=2 px>$c</font></td>";
print "<td align=left><font size=2 px>$d</font></td>";
print "<td align=left><font size=2 px>$$e</font></td>";
print "<td align=left><font size=2 px>$$f</font></td>";
print "<td align=left><font size=2 px>$$g</font></td>";
print "<td align=left><font size=2 px>$$h</font></td>";
print "<td align=left><font size=2 px>$$j</font></td>";
print "<td align=left><font size=2 px><a href=../equipment_reports/equipment_history.php?var=$k>$k&nbsp;</a></font></td>";
print "<td align=left><font size=2 px>$l&nbsp;</font></td>";
++$i;
}
?>

[dreamcatcher]

Hi knippysing

I believe the function you need is number_format.

[uk.php.net...]

echo number_format($d,2);

dc

[knippysing]

That's - I'll try and figure it out with this.

[knippysing]

That was what did it. I knew it was something simple that I was missing but I just missed it.

As always, you guys are fabulous, even with easy stuff!