Whoever Posted August 24, 2003 Share Posted August 24, 2003 Suppose I have a table TASKS, that contains, well, tasks and related information, such as name, startdate, enddate, infotext and such. And I have another table USERS that contains user information, such as..well, what usually goes into a USER table. Now Im trying to find some way of having a TASK have multiple users associated AS WELL as a USER having multiple tasks associated. Any idea how to do that? Thanks in advance Link to comment https://forums.phpfreaks.com/topic/936-design-issues-help-needed-warning-noobwork-here/ Share on other sites More sharing options...
effigy Posted August 24, 2003 Share Posted August 24, 2003 something like this, i believe: users: ===================== | userid | username | ===================== | 1 | bob | ===================== tasks: ===================== | taskid | taskinfo | ===================== | 1 | mop | ===================== | 2 | vacuum | ===================== assignments: ============================== | assignid | taskid | userid | ============================== | 1 | 1 | 1 | ============================== | 2 | 2 | 1 | ============================== Link to comment https://forums.phpfreaks.com/topic/936-design-issues-help-needed-warning-noobwork-here/#findComment-3153 Share on other sites More sharing options...
Whoever Posted August 24, 2003 Author Share Posted August 24, 2003 thanks effigy, I actually got the same answer from another person about 30 minutes ago, but its nice to see it validated! Thanks Link to comment https://forums.phpfreaks.com/topic/936-design-issues-help-needed-warning-noobwork-here/#findComment-3154 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.