"); echo("
"); $count = 0; while ($row = db_fetch_assoc($schools)) { extract($row); $school_num = $record_num; $span = ""; echo("$expiry_date - $span$school_name ($start_date - $status)
\n"); $numSchedules = db_getVal("SELECT count(*) FROM hotlunch_schedules WHERE school_num = $school_num"); echo("Schedules: $numSchedules
"); $query = "SELECT * FROM school_contact_list WHERE school_num = $school_num ORDER BY sequence,record_num"; $contacts = db_query($query); while ($row = db_fetch_assoc($contacts)) { extract($row); echo("    Name: $contact_name
"); echo("    Phone: $contact_phone
"); if (strlen($contact_email)) echo("    Email: $contact_email
\n"); echo("
\n"); } echo("
\n"); echo("
\n"); $count++; } echo("
"); echo("
"); echo("