How to setup a Rolodex?

[Squintz]

If im creating a rolodex to contain unique id#, names(first, last), adresses(street1, Street2,city,state,zip), phone numbers(home, work, cell) e-mail adresses(home, work), Comments

How would this be organized?

Would i only use one table or multiple tables?
How would i set up each column. (Name, Type, Null,Key, Default,Extra)?

Could someone organize this for me. I am trying to learn PHP and MySQL but i just havent figured out the database design part yet and i want to create a rolodex for my site.

Thanx for any help!

[percept]

I'm no expert by any means and a beginner at php/mysql but what I do know is that a front administration progam is the way to go... PhpMyAmin is what I use but i've also heard that something like MySqlfront is good as well.

If you can take a bit of time to learn the admin tool, it will create your tables and syntax for you... then you can create queries and get the php code for it to put in your scripts.

It looks like the info you want to store could easily go into just one flat table, making your interaction with it a lot easier for starting out.