I'm sorry because i'm pretty sure this was asked like a hundred times before, but my problem is, i dont even know what to search for exactly.
I created a site for our organisation were admins can create events and the users are able to join them.
I already wrote the login, the overview of the events and the form to create users and new events.
I have 2 SQL tables atm
'users' (ID, name, pw, etc.)
'events' (id, name, adress, etc.)
Hey I think it's a pretty simple foreign key. The conventional way is to have a table to map them together.
Tables: users (id, name,...) - all the different unique users events (id, title,....) - all the different unique types of events users_events (fk[users.id], fk[events.id]) - map users to events
Let me know if you need any more help!