\n"); exit(); } include "db.php"; $reseller = $argv[1]; $today = date("Y-m-d",time()); $query = "SELECT school_name, address, city, province FROM schools WHERE status = 'Active' AND reseller = '$reseller' AND expiry_date > '$today' ORDER BY school_name"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { extract($row); // echo("$school_name - $address, $city $province\n"); echo("$school_name\n"); } ?>