So i'm new to all this and have, what should be, and ease question.
I've successfuly modified the store locator example
(http://code.google.com/apis/maps/articles/phpsqlsearch_v3.html) to fit my
data. I've also added a dropdown menu to run a select statement on the .xml
page. It works when I pass the following address
(......_xml_domnew.php?lat=39&lng=-77&radius=10000&Juris=PG, note the PG
value) to the xml. However, what do i do to select all Juris (I have many
Juris values). Here is the select statement I use:
// Search the rows in the markers table
$query = sprintf("SELECT Juris, Cost, lat, lng, ( 3959 * acos( cos(
radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) -
radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS
distance FROM ARP_projects WHERE Juris = '$Juris"",
mysql_real_escape_string($Juris),
mysql_real_escape_string($center_lng),
mysql_real_escape_string($center_lat),
mysql_real_escape_string($radius));
What do I need to do to select all records in the Juris Column?
Any help?
--
You received this message because you are subscribed to the Google Groups
"Google Maps JavaScript API v3" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-maps-js-api-v3/-/I_fQJmEgFQMJ.
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-js-api-v3?hl=en.
