Hi
Try
// 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 =
%s 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($Juris),
mysql_real_escape_string($radius));
Regards Davie
On Jun 15, 4:45 pm, mwcog mwcog <[email protected]> wrote:
> 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 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.
