How do I go about this?

[sixii]

I'm programming a Gaming Ladder/Tournament system.

Let's say I have the following tables:

PLAYERS
-------
* Player_ID
* Player_name
...
* Team_ID

TEAMS
-----
* Team_ID
* Team_Name
...
* Ladder_ID

LADDERS
-------
* Ladder_ID
* Ladder_Name
* Ladder_Description
...

The question is about the 'Ladder_ID' field in the TEAMS table.

For instance, when a team joins 2 ladders/competitions, how do I store this?

Do I fill the LADDER_ID field with an ARRAY of values? Is there a better way to associate teams with multiple Ladders?

Tia.

[Slade]

I would stretch out the structures to a few more tables. Example:

Take TeamID out of Players. Make a table for Team members: create table team_members (team int, member int); Now a player can join several teams.

Take LadderID out of Teams. Make a table for LadderMembers: create table ladder_members (ladder int, team int); Now a team can be listed in several ladders.

[sixii]

Fantastic.

duh@me

Thanks a lot!