mshita Posted August 25, 2012 Share Posted August 25, 2012 I'm having some problems with this query SELECT * FROM locations WHERE acos(sin(45.5367737) * sin(lat) + cos(45.5367737) * cos(lat) * cos(long - (-122.8671799))) * 6371 <= 0.02 It gives me the following error 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 'long - (-122.8671799))) * 6371 <= 0.02' at line 1 Any help would be greatly appreciated!!! Quote Link to comment Share on other sites More sharing options...
mshita Posted August 25, 2012 Author Share Posted August 25, 2012 I figured it out....I used"long"....changed it to lng and worked fine Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.