Question how to get data from a SQL server

[siphis]

i am wanting to create a program that would search postal codes by searching the city, or display the postal code(s) if you search by city. I would be using SQL, i just want it to work for local host atm. This is currently the form:

part of the database code is

INSERT INTO `postal_code` (`postal_code_id`, `postal_code`, `province`, `city`)

(1, X0A0A0, NV, ARCTIC BAY), (2, X0A0B0, NV, QIKIQTARJUAQ), (3, X0A0C0, NV, CAPE DORSET), (4, X0A0E0, NV, CLYDE RIVER)

thanks in advance

 

[jmcilhinney]

Follow the Data Walkthroughs link in my signature and check those that are appropriate. Post back with any specific questions you may have.