'); $kml[] = ''; $kml[] = ' '; $kml[] = ' '; $kml[] = ' '; // Iterates through the rows, printing a node for each row. while ($row = @mysql_fetch_assoc($result)) { $kml[] = ' '; $kml[] = ' ' . htmlentities($row['name']) . ''; $kml[] = ' ' . htmlentities($row['address']) . ''; $kml[] = ' #' . ($row['type']) .'Style'; $kml[] = ' '; $kml[] = ' ' . $row['lng'] . ',' . $row['lat'] . ''; $kml[] = ' '; $kml[] = ' '; } // End XML file $kml[] = ' '; $kml[] = ''; $kmlOutput = join("\n", $kml); header('Content-type: application/vnd.google-earth.kml+xml'); echo $kmlOutput; ?>