I have the following code pulling financial data out of a database and would like to format to include a comma i.e. $10,000.00 vs. $10000.00.
Any help would be apreiciated as I am less than a newbie at PHP!
$sql="select id,date,billable,description,amount from financial_expenses where proj=$proj order by date";
$result = CRM_run_query($sql);
$EntryList="";
$LayerScript="";
$TotalBillable=0;
$TotalNonBillable=0;
while($myrow=mysql_fetch_array($result)){
$EntryList.="<tr>";
$EntryList.="<td width='5%' bgcolor='#F2F2F2' align='center' height='10' nowrap>".$myrow["date"]."</td>";
$EntryList.="<td width='3%' bgcolor='#F2F2F2' align='center' height='10'>";
if($myrow["billable"]) {
$EntryList.="Yes";
$TotalBillable += $myrow["amount"];
}
else {
$EntryList.="No";
$TotalNonBillable += $myrow["amount"];
}
$EntryList.="</td>";
$EntryList.="<td width='47%' bgcolor='#F2F2F2' align='left' height='10'> ";
$EntryList.="<a href='#' onMouseUp='return false' onMouseDown='ShowMenu(\"rjLayer".$myrow["id"]."\")'>".$myrow["description"]."</a>";
$EntryList.="</td>";
$EntryList.="<td width='9%' bgcolor='#F2F2F2' align='right' height='10'>".sprintf("%.2f",$myrow["amount"])."</td>";
$EntryList.="</tr>";
$LayerScript.="print_rjlayer('rjLayer".$myrow["id"]."', '".$myrow["id"]."');\n";
}
$GrandTotal = sprintf("%.2f",$TotalBillable+$TotalNonBillable);
$TotalBillable=sprintf("%.2f",$TotalBillable);
$TotalNonBillable=sprintf("%.2f",$TotalNonBillable);
