GoFuckYourself.com - Adult Webmaster Forum

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - zip code DB? (https://gfy.com/showthread.php?t=824402)

anybody have a DB of zip codes? I need something that has the city and state for me so instead of filling in those 2 fields I'll only have to put in the zip code.

http://www.micahcarrick.com/04-19-20...lculation.html

ended up importing that DB and yanking out the shit I didn't need so many places trying to charge for this LOL

google is your friend. I remember it took me a while to find one but you can find freely available ones that are a few years old.

They updated in Jan '08. I figured I might as well get a new import. This is a really bad DB schema, but it was mostly just to get it out of CSV. Enjoy.

Code:

CREATE TABLE `zipCityData` (

  `localid` int(10) NOT NULL auto_increment,

  `zip` varchar(5) NOT NULL,

  `city` varchar(64) NOT NULL,

  `state` varchar(2) NOT NULL,

  PRIMARY KEY  (`localid`),

  KEY `zip` (`zip`)

) TYPE=INNODB  AUTO_INCREMENT=41755;

localid is just for a numeric index so you have a non-zipcode key. Since this is probably going into MySQL of an unknown version (3.2.23 to 5.x), I decided to ensure it wouldn't corrupt the numbers by making them varchar. Whatever you wanna do with it, it's yours.