As far as I know US zip codes the general code like 90210 is for a large chunk of a city or even a whole city - like the first three digits/letters of a Canadian postal code. The additional numbers are for more of a refinement.
To get the results of a search near a location someone enters (i.e. your zip code) you need to know the latitude and longitude of the ZIP address center and the long/ lat of all the locations in your DB. Then when someone enters a ZIP you get lat/long and search for all places of interest within X miles from that lat/ long. Alternatively, you could just get a city name from the zip and return all places that are of interest in given city. The first method requires a piece of software or a paid service called a geocoder. The second is more "primitive" and you just need a database that maps all postal codes/ ZIP to cities. Yes, you can have a DB with all the zip codes mapped to lat and long but you still need a way to get lat/long of all the points of interest. TK www.tomkitta.com -----Original Message----- From: John Eubanks [mailto:[EMAIL PROTECTED] Sent: Monday, October 02, 2006 10:57 AM To: CF-Talk Subject: Zip Code Question I have a great question, and could use some help on it. I am trying to integrate a search function based off of zip code (one of those things where you enter your zip code and the results near you come back). However, I am having issues with it, and how the zip code structure works. Any assistance would be very greatful. John Eubanks 3i Webmaster, Electronic Communications Phone: 561-776-7204 Fax: 561-514-6326 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
