<?php

include "db.php";

$Years = array();
for ($i = 5; $i >= 0; $i--) {
   $Start = date("Y",time()) - $i;
   $Next = $Start + 1;
   $Years[] = "$Start/$Next";
}


for ($i = 0; $i < count($Years); $i++) {
   $syear = $Years[$i];
   echo("$syear\n");

   $query = "SELECT payment_method,sum(amount_paid) AS amount FROM invoice_header WHERE school_year = '$syear' AND status = 'Paid' GROUP BY 1";
   $results = db_query($query);

   while ($row = db_fetch_assoc($results)) {
      extract($row);
      printf("%20s: %14s\n",$payment_method,"$".number_format($amount,2));
   }

   echo("\n");
}

?>