";
$sql = "select airport_fields_1.name, airport_fields_1.internet_access,
airport.code, country_fields_1.name as countryname
from airport.airport_fields_1, airport.airport, airport.country_fields_1
where airport.airport_id = airport_fields_1.airport_id
and airport_fields_1.language_id = 1
and country_fields_1.language_id = 1
and airport.country_id = country_fields_1.country_id
and internet_access is not null
and internet_access != ''
order by countryname, name";
$st = DB::q($sql);
$last_country = null;
while ($row = $st->fetch_assoc())
{
if ($row['countryname'] != $last_country)
{
echo "
{$row['countryname']}
";
$last_country = $row['countryname'];
}
echo "
{$row['name']} ({$row['code']})
{$row['internet_access']}";
}
echo "