49 lines
943 B
PHP
49 lines
943 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
echo("<pre>\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("</pre>\n");
|
|
echo("\n");
|
|
echo($Names);
|
|
echo("\n");
|
|
?>
|