Google Maps database near points

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 this center :

map.setCenter(new GLatLng(".$initial_lat.",".$initial_lng.") ; 

how to display the markers in the Google Maps ?
Please I tried before the distance calculation of My SQL :

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.

Please do not cross-post the same question more than once.