Advice needed on mysql relationships / design

[jcstanley]

Hi

 

I have a mysql database which is used to run a club website, but I am not quite sure how to set up some relationships.

 

I have a table called ' Members' containing all the members names etc.

 

The club has a number of committees and each member can belong to more than one committee.

 

Therefore I have created another table called 'Committees' listing all the different committee names.

 

Thats where I get stuck.  How do I associate the members with the committees.  What I intend to do is have a webpage for each commitee displaying all of the members whithin that committee.

 

Hope this is making sense.  If you need more info please just ask.

 

Many thanks

[vijayfreaks]

Hi..

        For that create one more table that will contain member_id and committees_id as foreign key from relative table.

 

Regards,

Vijay

[pranav_kavi]

i suppose u wud b ving a memberID in ur 'Members' table and committeeID in ur 'Committee' table.

 

Have a join table like 'committee_members' that has 2 columns-memberID  & committeeID  .so this table wud store the mapping information.

 

hope tis helps..

[jcstanley]

thanks for that.  just one more question - I am using phpmyadmin, how do you create foreign keys to link the tables?