I have a mySQL table full of zipcodes and their related latitude and longitude. I need a cfc/query to find zipcodes within X (#range#) miles from a given latitude and longitude coordinate.
The output should be a list of zipcodes (ie. 92110,92115,92116,92118) within a defined distance.
table: zipcodes
|ZIPCODE|CITY|STATECODE|STATENAME|LATITUDE|LONGITUDE|
Attached is a small section of the “zipcodes” table.
