Thanks Guys It's working OK Now
Just in case anyone else reads this I changed //Start xml file
$dom = new DOMDocument ("1.0");
$node = $dom->createElement("markers"); Changed to" marker" through
this script fixed. Thanks again for the help appreciated.
On Nov 27, 6:25 pm, Andrew Leach
wrote:
>
Thanks for the replies, sorry if the info was short details below:
createElement("markers");
$parnode = $dom->appendChild($node);
// Opens a connection to a mySQL server
$connection = mysql_connect ($db_server, $db_user, $db_password);
if (!$connection) {
die("Not connected : " . mysql_error());
I am still testing, but think I have a problem with query SELECT
address, name, lat, lng, ( 3959 * acos( cos(radians('%s')) * cos
(radians( lat ) ) *cos(radians( lng ) - radians('%s') ) + sin( radians
('%s')) * sin( radians( lat AS distance FROM markers HAVING
distance < '%s' ORDER BY distance
