G’day, you can export KML from your database by building it up as an XML feed. KML is just XML with a specific set of elements; read the KML tutorial for more information. Take a look at this really simple example file to see how to structure a KML map with multiple addresses.
If you are exporting the data from a WordPress website, I suggest you use the AJAX interface as it will greatly simplify pulling direct data from WordPress. Here’s some example code for pulling XML from WordPress (read the first code snippet in the section Pulling XML from WordPress and processing in Classic ASP).
Because you will be dynamically generating the KML, you’ll need to prevent Google Maps from caching your KML (it reads it once and caches it, so if it changes, you’ll need to bust the cache). See the support topic Dynamically generated KML for more information.
cheers,
Ross
