• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need Help With Exploding CSV Data Within DB

#1
[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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.