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/dd6255740040d317/068b6f8d8bf314c0?lnk=gst&q=another+radius#068b6f8d8bf314c0 -- 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 -~----------~----~----~----~------~----~------~--~---
