I'm trying to implement a radius for areas in miles around a certain post code. I have a table in my DB called locations that contain the columns easting and northing. How do I use these to search for all the locations with a 5 mile radius of a certain postcode???
I have looked at all the posts here and there is loads of different codes to work out distance between two points but I can't work out how to adapt it to do what I want it to do.
Is there a post that covers this if so can you point me in the direction of it? If not could you please give me an idea how I should go about this mind boggling task!