Hi
Sorry one comma too many .It happens when you cut and paste in a
hurry.
// 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 18, 11:01 pm, davie <[email protected]> wrote:
> 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.
