Forum table help!

[Alexandros Panayi]

Hello everyone.

I am creating a forum, and I am having a bit of trouble issuing moderators per category.

The problem I have is that, lets say I have a user called "user1" and this user1 is a moderator of 2 categories: "General" and "Off topic"

However, when I go on my table to search the records, it says user1 is the moderator of only "Off Topic" but it doesn't show "General." It's like the column only shows 1 value and cannot accept more?

User table:
uid int(11) auto increment,
fname varchar(20),
Uname varchar(15),
pwd varchar(15),
Fmod varchar(30) references forum(name) *this links the user to a moderator of a category*

forum table:
name varchar(30) primary key
moderator varchar(15) references user(name) *this links the forum moderator to the user*