|
I have the zip code database on a network - mySQL, i need to do a radius search -(Enter a zip code, radius, and get all zip codes in that radius. So I guess I need an SQl statement, Function or Sproc, that will return those results? Psuedocode: Select Function("zipcode","radius") where zipcode="" and radius="";
(zip code and radius are passed in from a form)
A web service if I could find one would do the trick as well, but since i have the data, a solution using mySQL might work as well. I use JSP pages and have php available too.
|