CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   MySQL (http://www.codingforums.com/forumdisplay.php?f=7)
-   -   User and group managing (http://www.codingforums.com/showthread.php?t=198686)

Pcfr43k 06-22-2010 04:14 PM

User and group managing
 
Im trying to build a website in PHP with users in groups.
What is the best way to manage that?
Table with groups, table with users and what group the're in - and the rest in PHP?
Or is there a better way to do this?

Every user is going to be member of a group in the website.

Fumigator 06-22-2010 04:48 PM

I would do three tables: members, groups, and members_groups cross-reference. This way a member can be in any number of groups, just put the relationship in the cross-reference table.


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.