I've a USA zip code database in Mysql Format. The mysql file is already setup for you, What I want is there must be a search form where let say user input there zip code for instance 14623 , the form search the database and provide information, the database is setup like this right now :-
INSERT INTO zip codes VALUES (14623,'Rochester','NY','43.087613','-77.635200',-5,1)
with columns for Instance : -
ZIP code, city, state, latitude, longitude, timezone (offset from GMT), and daylight savings time flag (1 if DST is observed in this ZIP code and 0 if not).
The form will print the following information stating :-
Our Technicians are available in Rochester, NY ZIP CODE 14623
Time Zone : -5
Please call # 000-000-000
What I want is a very small admin panel where I can add zip codes and necessary information such as ZIP code, city, state, latitude, longitude, timezone if there is any new available.
Also right now my services is available in Rochester,NY so it will only show Rochester,NY like above how I gave you an example ...
In future if my services are available in for instance Rushville,MO I must have an option thru the ADMIN Panel where I can add where my services is available for instance If I add in admin panel 64484 and if the user search the form by entering there Zip code it will say
Our Technicians are available in Rushville,MO ZIP CODE 64484
Please call # 000-000-000
And if the user entered 64485, it will say our services are not available at this area please try back later.
Thanks,