On Mar 20, 6:41 pm, donovan78 <[email protected]> wrote: > Hi , what is the MySQL 5.0 query needs to select geo > coordinates( latitude,longitude) from locations database > within a radius of 100 miles around
That's not a Maps API question. See here: http://maps.forum.nu/gm_drag_polygon.html -- Marcelo - http://maps.forum.nu -- this center : > map.setCenter(new GLatLng(".$initial_lat.",".$initial_lng.") ; > and display this markers in the Google Maps ? > Please I tried before the distance calculation of My SQL : > > (3963*acos(cos(radians($initial_lat))*cos(radians(lat))*cos(radians(lng)- > radians($initial_lng))+sin(radians($initial_lat))*sin(radians(lat)))) > AS distance FROM agoda_hotel > WHERE agoda_hotel.country_id = 205 > HAVING distance < 100 > > however it' s not select locations nearby the center above > correctly. I am newbie in MySQL programming and may be I > could not found the exact function. > 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.
