handling groups

[acke1976]

hey, i am looking for help for handling users. What I want is a list of available members taken from a mysql database and be able to put them in to groups using choiceboxes or something simular. My goal is to be able to create new groups otr editing old groups and that one user could be member of many groups, is it anyone who have been working with something similar to this. Any help appreciated.

Axel

[dnszero]

Just create a table to keep track of the groups, something like:

create table groups (
gid int unsigned auto_increment,
gname varchar(40)
);

Then create another table to keep track of which users are in which groups:

create table usergroups (
ugid int unsigned auto_increment,
userid int unsigned not null,
groupid int unsigned not null
);

Then to add a user to a group just:
"INSERT INTO usergroups VALUES ('', '$UserIdFromYourUserTable', '$gidFromGroupsTable');"
And do this for each group the user is in.

[acke1976]

seem like a smart idea, but i keep on getting this message when running the sql:

Incorrect table definition; There can only be one auto column and it must be defined as a key

what does that mean?

[dnszero]

My bad, I think that you will need to add "primary key" to both of those lines with auto_increment in them, like:

gid int unsigned auto_increment primary key,

and the same for the other one.