I am looking for a way to find addresses in my db by entering a postal code and radius.
- Contacts (postcode, city)
- Postal codes with geocodes (LAT/LON)
The both tables are related over the ZIP field.
I have created the CF GeoBoxBounds (https://www.briandunning.com/cf/1491) and it will calculate by entering a postal code and a radius. Now, I get in the calculation field 4 values:
Now I would have to use a script over these values from the CF, in order to find the appropriate results.
But how should I build the search here?
I have attached an example so that my approach can be better understood.
Would be very grateful for help and support.