Posted: Thu Apr 26, 2007 11:09 pm
I can help you there, the database dump, once I find it, also has the lat and lon for the zip code. This along with a little math will let you do a radius search.
Lets say I living in Seagraves Tx want to find all the 30.06 signs reported to your site in say 100 miles of my location could enter my zip code and choose 100 miles by either entering it or selecting it from a drop down menu (suggested).
Once I click submit the php script would do some math and determine what latitudes and longitudes make up the 100 mile radius and then search the DB for signs that the zip codes fall into that area. In my case that should return results from roughly Lubbock to Odessa. The down side is that it would add additional DB queries to the script and db unless the database is extended to include lat/lon (The end user would never have to see this as it could be input based on city name and/or zipcode)
Lets say I living in Seagraves Tx want to find all the 30.06 signs reported to your site in say 100 miles of my location could enter my zip code and choose 100 miles by either entering it or selecting it from a drop down menu (suggested).
Once I click submit the php script would do some math and determine what latitudes and longitudes make up the 100 mile radius and then search the DB for signs that the zip codes fall into that area. In my case that should return results from roughly Lubbock to Odessa. The down side is that it would add additional DB queries to the script and db unless the database is extended to include lat/lon (The end user would never have to see this as it could be input based on city name and/or zipcode)