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 LIMIT 0 , 20". etc
It would seem if I run this in mysql it shows no stores which is the
return I also get when using the map
http://www.easzy.co.uk/store_locator/index.php.
The xml http://www.easzy.co.uk/store_locator/genxml.php
If I run the query "SELECT * FROM markers WHERE 1" I get the stores
currently listed http://www.easzy.co.uk/store_locator/gemxml.php
I have been over this several times, I know I am missing something can
anyone help please to put me on the right track? Using php 5
Many Thanks
--
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
