Use three tables, one from projects one for members one for assignments
and whatever else
so each member can be in one or many projects and each project can have one
or many members
if members can only be on one project then you could in theory do it with
so to sellect all members of project with id X
SELECT m.* FROM members m, workingon w WHERE m.memberid=w.memberid AND
Hope this helps,
----- Original Message -----
From: "garman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 2:53 PM
Subject: [PHP] storing team members---suggestions on approach?
> I've got a fairly simple problem, and I'm not really sure how to approach
> I'm creating a website for team projects, where the project information is
> stored in a MySQL database. I want folks to be able to name their
> indicate it's length, have a verbal description, etc. The gathering and
> handling of that information is fairly straightforward.
> Each team project obviously has team members. But the number of team
> is variable. Furthermore, team members can be in one of two categories.
> not really sure how I should best store team members in the database.
> Ideally, it would be nice to have a database field for every team member,
> if there is ever a team with one more member than I have fields... that's
> big problem. So my other thought was to just have two fields for team
> (one for each category), and within that field just have a comma (or
> semicolon, etc) delimited list of employee names. Another thought is to
> a table just for employees, where one field of that table maps the
> a project (project are contained in another table). That table could also
> have a field that indicated the member's category.
> Any thoughts on my current ideas, or suggestions for something better?
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]