Hi! I am looking at the PHP/MySQL store locator example here:
http://code.google.com/apis/maps/articles/phpsqlsearch.html And I'm trying to get this to work with PostgreSQL instead of MySQL. I've (slightly) modified the haversine formula part of my PHP script but I keep getting this error: Invalid query: ERROR: column "distance" does not exist LINE 1: ...ude ) ) ) ) AS distance FROM aaafacilities HAVING distance <... ^ I'm new to this, but it doesn't look like I need to create a column in my table for distance, or at least the directions didn't say to create a distance column. Here is my PHP with SQL: $query = sprintf("SELECT 'ID', 'FACILITY', 'ADDRESS', latitude, longitude, ( 3959 * acos( cos( radians('%s') ) * cos( radians ( latitude ) ) * cos( radians( longitude ) - radians('%s') ) + sin ( radians('%s') ) * sin( radians( latitude ) ) ) ) AS distance FROM aaafacilities HAVING distance < '%s' ORDER BY dist LIMIT 0 OFFSET 20", pg_escape_string($center_lat), pg_escape_string($center_lng), pg_escape_string($center_lat), pg_escape_string($radius)); Does anyone have any ideas on how I can get this to work? I did search the group and didn't find anything specific to PostgreSQL. Thanks! Jonathan Harahush --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
