Need Help With Exploding CSV Data Within DB

Need Help With Exploding CSV Data Within DB

El Forum
Guest

02-12-2009, 03:54 PM

[eluser]Jay Logan[/eluser]
Trying to figure out the best practice here. I have a table that stores several zip codes for a store location. The zip codes are CSV. They SHOULD all be unique zip codes for each location but I'm not banking on that.

I just added a table full of every zip code in USA (over 80,000 rows) and it has data such as city name, county name, latitude, longitude, etc. What I want to do is look up a location and display geographic information based on which zip codes are stored in the database with the location. So if a user goes to one of my locations web page, they will see all the counties and cities that are associated with it.

Any suggestions?

Messages In This Thread

Need Help With Exploding CSV Data Within DB - by El Forum - 02-12-2009, 03:54 PM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-12-2009, 05:16 PM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-12-2009, 05:22 PM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 07:23 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 07:30 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 07:38 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:02 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:08 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:11 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:15 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:25 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 08:32 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 09:12 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 09:29 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 10:40 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 10:46 AM

Need Help With Exploding CSV Data Within DB - by El Forum - 02-13-2009, 11:12 AM