Marcelo, Thanks for replying.
I have tried your query and it is here: http://www.gaspares.com.au/map1.html When I run the script it says: Line 39 character 8 documentElement is not an object or null this is the line of code it refers to: var markers = xml.documentElement.getElementsByTagName('marker'); does that mean the php isnt returning an answer? I am not sure how to test the script to see if it is sending an xml result. Thanks again for your help On Feb 9, 3:50 pm, marcelo <[email protected]> wrote: > On Feb 9, 2:58 am, jthor <[email protected]> wrote: > > > You can see my map herehttp://www.gaspares.com.au/map3.html > > put in any Australian Postcode eg. 4504 - it returns all 2500+ entries > > if you let it run long enough. If you go > > here:http://www.gaspares.com.au/map.html > > you can see the php return xml for the one entry in that postcode. > > The issue would seem to be your SQL statement. You need the correct > 'where' and 'order by' clauses, and perhaps a 'limit' (MySQL) or > 'Top' (MSSQL), to sort and limit the results of the query. > That's not really a Google Maps API issue, but here you have a SQL > statement for a radius search, which is better than the Haversine > formula, especially for long > distances:http://groups.google.com/group/Google-Maps-API/browse_thread/thread/d... > > -- > Marcelo -http://maps.forum.nu > -- --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
