Hi,

I use Agendax for my events. I run a partysite en all the upcoming party's are displayed in agendax.

What i want to have is that users can just click a button so their name will be stored in the database "John is visiting this event" so every user can see all members visting that party.

I also like to see in a users profile wich events they are going to.

I believe if i make an extra table with the ID, EVENTID and USERID it's done. The only thing i don't know is how to combine the tables and display the info.

Can anybody help me with this ? I can't believe it's that hard or impossible.

You probably only need a table with eventid and userid with a joint primary key (`eventid`.`userid`)

Then to get the events, a user is going to, you just need to ask
"SELECT eventname, eventdate [and more info about the event] FROM [eventtable], [relationtable] WHERE [relationtable].userid=$userid AND [relationtable].eventid=[eventtable].eventid"

Or something like that.