\n"); $yr = date("Y",time()); $query = "SELECT * FROM schools WHERE province = 'NB' AND status = 'Active' ORDER BY school_name"; $query = "SELECT * FROM schools WHERE province = 'NB' AND status = 'Active' AND expiry_date < '$yr-12-31' ORDER BY school_name"; $results = db_query($query); $count = 1; $paid = 0; $unpaid = 0; $Names = ""; $Line = ""; while ($row = db_fetch_assoc($results)) { extract($row); $flag = ' '; if ($expiry_date < '2026-12-31') { $flag = '*'; $unpaid++; } else { $paid++; } // printf("%3d: %s - %s\n\n", $count, $expiry_date.$flag, "$school_name - $address, $city"); echo("$school_name\n"); $count++; if (strlen($Line) > 70) { $Names .= trim($Line) . "\n"; $Line = ""; } $Line .= "$school_name, "; } echo("Paid: $paid\n"); echo("Unpaid: $unpaid\n"); echo("\n"); echo("\n"); echo($Names); echo("\n"); ?>