creating a table relationship

[lucilue2003]

Hello,

I have a table called Contacts. The table will have a firstname , lastname, and comments. it also needs to hold 1 or more phone numbers.
how do i do this ?

For example,
Table contact will have an entry for John Doe. He had a mobile phone and home phone and a work phone.

thanks.

I'm thinking this.. but it doesn't make sense though.

PSEUDOCODE:

create table contacts (
id auto-increment int
fname varchar
lname varchar
commetns varchar
)

create table phone {
id auto-increment int
number int
type varchar 'mobile, home, work
best time to call 'after 6
}

contacts_to_phones
(
id
contacts_id
phones_id
)

[goldlikesnow]

I don't get that unless multiple people share the same number you should keep it simple:

create table contacts (
id auto-increment int
fname varchar
lname varchar
commetns varchar
phoneHome
phoneHomeAfterSix (boolean)
phoneCell
phoneWork
)

[lucilue2003]

Hello,

Thats a very smiple solution but what if you have a person with only a home number and not work or cell, then you're gonna end up with nulls in your rows..

[ahundiak]

Unless you really need to share the same phone number record with multiple contacts then using a many to many relation is somewhat of an over kill. One to many should work and saves having to make a third table.

contact
..contact_id (auto-increment)
..name

phone
..phone_id (auto-increment)
..contact_id
..number (do not forget about area code and extension, and how about oversea numbers
..type (home, work etc)