[Plugin: SimpleMap] Creating XML from SQL results

Generic question for anyone, even if you don’t use this great plugin. I just decided I wanted to use the post/postmeta tables to get some added functionality only available to posts instead of the default tables with the plugin.

I’ve got a query that works in PHPMyAdmin, but it doesn’t seem to be creating the necessary XML for the mapping process through Google.

Author’s SQL

$query = sprintf("SELECT name, address, address2, city, state, zip, country, lat, lng, phone, fax, url, description, category, tags, special, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS distance FROM $table".$category_text."HAVING distance < '%s' ORDER BY distance".$limittext,
			mysql_real_escape_string($center_lat),
			mysql_real_escape_string($center_lng),
			mysql_real_escape_string($center_lat),
			mysql_real_escape_string($radius));

My alternate that pulls from posts/postmeta and works in PHPMyAdmin when I replace the variables with numbers

$query = "SELECT wp_1_posts.post_title, wp_1_posts.ID,
( 3959 * acos(
cos( radians( $center_lat ) ) *
cos( radians( CONVERT( latitude.meta_value, DECIMAL( 10, 6 ) ) ) ) *
cos( radians( CONVERT( longitude.meta_value, DECIMAL( 10, 6   ) ) ) - radians( $center_lng ) ) +
sin( radians( $center_lat ) ) * sin( radians( CONVERT( latitude.meta_value, DECIMAL( 10, 6 ) ) ) )
) ) AS distance
FROM wp_1_posts
LEFT JOIN wp_1_postmeta AS latitude ON ( wp_1_posts.ID = latitude.post_id
AND latitude.meta_key = 'lat' )
LEFT JOIN wp_1_postmeta AS longitude ON ( wp_1_posts.ID = longitude.post_id
AND longitude.meta_key = 'lng' )
WHERE wp_1_posts.post_status = 'publish'
HAVING distance < 50
ORDER BY distance".$limittext;

The author’s code below, creates and XML document later read by javascript to output markers on a Google map. For each line, I commented out her "stripslashes . . ."and replaced with a call to "get_post_custom_values()" function to try and retrieve the same data during the while loop.

No luck with my solution. I think the query’s solid since it’s tested in PHPMyAdmin, so I think it’s the XML creation. Please help.
If inclined the author’s code is in create-xml.php of the SimpleMap plugin in the repository.

header("Content-type: text/xml");

// Iterate through the rows, adding XML nodes for each
while ($row = mysql_fetch_assoc($result)) {

$node = $dom->createElement("marker", nl2br(stripslashes($row['post_title'])));
$newnode = $parnode->appendChild($node);

$newnode->setAttribute("name", $row['post_title']);  //stripslashes($row['name']));

$newnode->setAttribute("address", get_post_custom_values('address', $row['ID'])); //stripslashes($row['address']));

$newnode->setAttribute("address2", get_post_custom_values('address2', $row['ID'])); //stripslashes($row['address2']));

[. . . for additional nodes]

}
echo $dom->saveXML();