I need to allow people to search through a database of restaurants by typing in their zip code. When they type in their zip code it will show them the closest restaurant that we have in our database. Surely there is an easier way than typing every zip code in the country into a database? Thank you in advance.
Speaking of zip codes and databases, there are several free sources of zip code databases. That would be incredibly useful because these databases often contain the exact lat and long for a zip code, meaning you could run a function that would tell you every zip code within say 10 miles of a provided zip code, then you can pull each store/restaurant from the database that matches those zip codes. And since the databases are freely provided you wouldn't have to type in every zip code, just install it as a second database to serve that particular purpose.