I have a page where users are able to draw a polygon on a google map. I am posting the following variables through to the results page via a form:
minX (minimum longitude)
maxX (maximum longitude)
minY (minimum latitude)
maxY (maximum latitude)
The records in my DB table hold the latitude and longitude values and I would like to be able to select the records where the latidude and longitude fall within the area selected.
Can anyone advise of the sql syntax to be able to achieve this?
See following page as example of where I am at with this: http://www.bspc.co.uk/forsalemap.asp
Thanks for any assistance