phone numbers help

I know this is asking alot but I've never used mysql and php together before. I need to create a webpage that will allow the user to input a
area code and prefix then display a list of numbers for that prefix or city or state.
If someone would be so kind to help me along with this process I don't wan't someone to do it for me I would would just like some help in showing me how. Thanks in Advance

Thread moved from 'PHP Coding' to 'Programming Theory' by kendo.

Reason: Code Discussion in my opinion.

1. Design a HTML form interface with text fields and stuff to input area code, prefix etc.
2. Create a new mysql database table with specific data such as area code, prefix, city, state. And insert data to the table.
3. Then write a script to search for matching area codes in table and select matching data from table.
4. Finally, dislay search results in order.

This should be the basic idea/process. Start it and keep going... When you stuck, feel free to post problems here. Lot of cool gurus are ready to answer you!!!

Yakka is almost correct

I weould STRONGLY suggest he added globe to his dissertation

How hull do you need to make the ZIPs?

Under US law you have access to every 5 digit ZIP, going any further potentially abridges persoanl privacy

This means you can convert any 5zip into a town + state

You, ideally, run this off a few tables. One of the towns in the states (you need about 17MB for this one to be done properly) and another (much smaller) to do the ZIPs

I don't live in the US - but I need to know how the postal service works

Leave a message here if you need any more help (I'm very helpfull)

I would ask onje thing, your age

Note that I'm a registered codie

And I love this week's pol (definite yes)