"SELECT address, name, lat, lng, WHERE type= $type AND ( 3959 * acos(
cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) -
radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS
distance FROM markers HAVING distance < '%s' ORDER BY distance LIMIT 0
, 50"On Wed, Jun 9, 2010 at 12:20 AM, [email protected] <[email protected]> wrote: > On Jun 8, 10:17 pm, Harry Osoff <[email protected]> wrote: >> Did you try to view source? > > That code is on your server. View source only shows me the what the > server sends out, certainly not the source on your server. > > -- Larry > > >> >> On Tue, Jun 8, 2010 at 11:52 PM, [email protected] >> >> <[email protected]> wrote: >> > On Jun 8, 8:59 pm, Harry Osoff <[email protected]> wrote: >> >>http://1537news.com/Search_XML.php?lat=41.7917833366732&lng=-87.59100... >> >> >> I started with the Google example of a store locator and want to add >> >> the ability to search by store category >> >> but nothing I have tried today will make the query ...Query. >> >> >> Any suggestions? >> >> > Did you look at what that returns? >> > Invalid query: You have an error in your SQL syntax; check the manual >> > that corresponds to your MySQL server version for the right syntax to >> > use near 'WHERE type= Bank AND ( 3959 * >> > acos( cos( radians('41.7917833366732') ) * cos( ra' at line 1 >> >> > It looks to me like you have a single quote problem. But I can't see >> > the code. >> >> > -- Larry >> >> >> Harry Osoff >> >> Web Development >> >> 1537News.com >> >> > -- >> > 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 >> > athttp://groups.google.com/group/google-maps-api?hl=en. > > -- > 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. > > -- 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.
