PhotoPost Community - View Single Post

Chuck S · March 30th, 2005, 05:43 PM

Calli

I posted the query above to create the table here it is again. You can run this right on phpmyadmin

CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM

Then run the upgrade script and select install zip code data

March 30th, 2005, 05:43 PM	#16 (permalink)
Chuck S Photopost Developer Verified Customer Join Date: Jun 2002 Location: Abingdon,MD Posts: 68,044	Calli I posted the query above to create the table here it is again. You can run this right on phpmyadmin CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM Then run the upgrade script and select install zip code data __________________ Photopost Developer and Support Engineer Please do not PM me for support or sales questions. Thank you for your understanding.