Hello, I'm trying to follow Creating a Store Locator as per http://code.google.com/apis/maps/articles/phpsqlgeocode.html
I'm only trying to just get the SQL to work. I created the table and populated it with the examples provided. However, when I tried to execute the SQL that it provided: SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20; This executed without error but returned 0 rows. I then tried to lower the 25 mile radius to 1 mile and still it returned 0 rows. Has anyone gotten this to work? It seems odd that Google would post an article that doesn't work! Cheers, J -- You received this message because you are subscribed to the Google Groups "Google Maps API V2" 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.
