On Nov 27, 11:19 am, ianhg <[email protected]> wrote: > I am still testing, but think I have a problem with query SELECT > address, name, lat, lng, ( 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 , 20". etc > It would seem if I run this in mysql it shows no stores which is the > return I also get when using the > maphttp://www.easzy.co.uk/store_locator/index.php. > The xmlhttp://www.easzy.co.uk/store_locator/genxml.php > If I run the query "SELECT * FROM markers WHERE 1" I get the stores > currently listedhttp://www.easzy.co.uk/store_locator/gemxml.php > I have been over this several times, I know I am missing something can > anyone help please to put me on the right track? Using php 5 > Many Thanks
There's not enough information in your post. We can't see your server- side code; we only get the results. I'd guess you have no records which satisfy the criteria you're using for searching, but because we can't see the results of your "WHERE 1" query, we're unable to see where things might be going wrong. Andrew -- 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.
