On Dec 4, 12:23 pm, GREASE <[EMAIL PROTECTED]> wrote:
> below is my script that generates the XML data it works fine when the
> lat lon radius vars are hard coded
> // Select all the rows in the markers table
> $query = sprintf("SELECT description, name, lat, lon, ( 3959 * acos
> ( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lon ) -
> radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS
> distance FROM plants_classification HAVING distance < '%s' ORDER BY
> distance LIMIT 0 , 20",
> mysql_real_escape_string($center_lat),
> mysql_real_escape_string($center_lng),
> mysql_real_escape_string($center_lat),
> mysql_real_escape_string($radius));
>
>
> search produces no result ..can anyone tell me what is wrong ?
> can anyone please correct my search code ? give me an example ?
>
Please, please, please
1. read and follow the posting guidelines
http://groups.google.com/group/Google-Maps-API/web/suggested-posting-guidelines
(at least post a link)
2. don't yell.
-- Larry
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
