Ok, I have a little problem.... You probably hear that a lot.
Anyway, I want to have a "rating" field in the database that everyone can view, but only people with "moderator" or "admin" priviledges can modify.
Also, I have six or seven "groups", each of which has a moderator. Now, I don't want the moderator from the first group editing the rating on entries from the second group. Moderators can only edit ratings within their own groups.
I know one way to go around this is to have a separate database for each group. But then I would like to be able to search all the databases simultaneously.
How would I go about doing this?
Thanks in advance.
Anyway, I want to have a "rating" field in the database that everyone can view, but only people with "moderator" or "admin" priviledges can modify.
Also, I have six or seven "groups", each of which has a moderator. Now, I don't want the moderator from the first group editing the rating on entries from the second group. Moderators can only edit ratings within their own groups.
I know one way to go around this is to have a separate database for each group. But then I would like to be able to search all the databases simultaneously.
How would I go about doing this?
Thanks in advance.