MySQL help

[Gegenki]

CREATE TABLE events (
eventname varchar(50) primary key,
eventtime varchar(5) not null,
eventplace varchar(50)not null,
eventdesc varchar(255)not null,
csigned varchar (255),
eventlink varchar(100),
)

Thats a table I made.
under csigned i wanted it to have the names of everyone that had signed up to the event.
I have a members login and for each person that has logged in needs to be able to see all the events that they have signed up for but I can't work out how to do it.
My first idea was if their name appeared in csigned it would show that row, but a. I can only have 255 characters and b. I'd have to separate all the names.

Anyone got a solution?

[WolfmanNCSU]

Well, I would tackle this from a different direction. I would have a field in the Members/Signees Table that contains the EventID of the event they signed up for. For have that field point to a translation table that contains EventIDs with whatever codes you want to make.