Re: storing team members---suggestions on approach?

Use three tables, one from projects one for members one for assignments Projects ================ projectid projectname length description and whatever else members =============== memberid name category workingon ================ memberid projectid 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 tables so to sellect all members of project with id X SELECT m.* FROM members m, workingon w WHERE m.memberid=w.memberid AND w.projectid=X Hope this helps, ----- Original Message ----- From: "garman" <garman@students.uiuc.edu> To: <php-general@lists.php.net> 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 it. > 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 project, > 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 members > is variable. Furthermore, team members can be in one of two categories. I'm > 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, but > if there is ever a team with one more member than I have fields... that's a > big problem. So my other thought was to just have two fields for team members > (one for each category), and within that field just have a comma (or > semicolon, etc) delimited list of employee names. Another thought is to make > a table just for employees, where one field of that table maps the employee to > 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? > > Thanks! > Matt > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >