while ($row = mysql_fetch_array($result)) {
$total = $total + $row[5];
echo "<td><a href='irecord.php?record={$row['0']}' target='_blank'>{$row['0']}</a></td>";
echo "<td>{$row['6']}</td>";
echo "<td>{$row['2']}</td>";
echo "<td>{$row['1']}</td>";
echo "<td>{$row['4']}</td>";
echo "<td>\$" . number_format($row[5], 2) . "</td>";
echo "<td>{$row['7']}" . " y " . "{$row['8']}</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($conn);
echo "<center><h2><blockquote>Ingresos Totales: \$<b>" . number_format($total, 2) . "</b></blockquote></h2></center>";
include 'getYearTotal.php';
echo "<p>Ofrendas hasta la fecha: <b>\$" . number_format(YTDIncomeTotal(), 2) . "</b></p>";
echo "<center>";
print "<p><a href='Ofrenda-Anual-Detallado.php'>Reporte Anual</a> | <a href='index.php'>Inicio</a></p>";
echo "</center>";
?>
</fieldset>
</body>
</html>
<tr>
<td style="width: 514px"><fieldset><p><strong>Resumen Hasta La Fecha:</strong></p>
<?php
//Get Totals For Current Fiscal Year
include 'getYearTotal.php';
$income = round(YTDIncomeTotal());
$expense = round(YTDExpenseTotal());
$mission = round(yearMissionTotal());
$do = $income + $expense + mission;
$income = $income / $do * 100;
$expense = $expense / $do * 100;
$mission = $mission / $do * 100;
echo "<img src='http://chart.apis.google.com/chart?chs=250x100&chd=t:{$income},{$expense},{$mission}&chco=00FF00|FF0000|0000F4&cht=p3&chl=Ingresos|Gastos|Misiones' >";
echo "<p>Ingresos : <span id='ingresos'><b>+\$" . number_format(YTDIncomeTotal(), 2) . "</b></span></p>";
echo "<p>Gastos : <span id='gastos'><b>-\$" . number_format(YTDExpenseTotal(), 2) . "</b></span></p>";
echo "<p>Balance : <span id='cambio'><b>\$" . number_format(YTDIncomeTotal() - YTDExpenseTotal(), 2) . "</b></span></p>";
echo "<br/>";
echo "<p>Total Misiones: \$" . number_format(yearMissionTotal(), 2) . "</p>";
?>
</fieldset></td>
<td> <form accept-charset="utf-8" action="vreport.php" method="post" name="viewreport">
<fieldset><legend><b>Reportes</b></legend>
<blockquote><p>Reportes : <select id="vreport" name="vreport">
<option value="query">Buscar Record</option>
<option value="personreport">Reporte Personal</option>
<option value="FechaOfrendaSemanal">Reporte Semanal Ofrendas</option>
<option value="FechaOfrendaMensual">Reporte Mensual Ofrendas</option>
<option value="OfrendaAnual">Reporte Anual Ofrendas</option>
