Re: Zip Code Proximity search - Examples II

[Thomas Butler]

I'm just getting started implementing a zip code proximity search to my web search screen. I've read through this thread and viewed most of the URL references. It looks like this is still going to take some work - what is the easiest approach to:

* populate mysql w/ US zip code info (i.e., zipcodeworld, myzipcodedb, other)
* construct query to find all stores within a specified zip radius (proximity specified by the user) that also offer keyword items specified by the user (i.e., users specify multiple keywords + zip code + zip code radius)

I have the keyword search against the database set up and now I'm trying to implement the zip code radius search. I'm using Java Server Faces (Oralce 10g Jdeveloper) as the front-end and MySQL 5.0 for the database. I'd like to be able to do the entire query within a single sql statement if possible.

Any suggestions, java code examples, etc. to complete this task quicky and easily?

thanks
Tom