Need a little guidance

[1042]

Hi all,

i have a question and i was wondering if someone could get me on the right track, im building a site for members, i have the login part completed, within this site i have an events page also, on the admin part the user can add events for others to see, my events table is simple:

ID
Tittle
Content

what i need to do is allow the members to register for an event, for instance if they are reading the events i want to display a link that would say "register for event" and they can just click and register since they are already logged in, my question is should i make another table to hold the users that register for a particular event? and then have the link (thru a php script like a newsletter system )add their user name to that event? also how would i tell the system what users are register for a particular event (how would i combine both tables the events table and the users table) , i hope i made sense, i thank anybody in advance for the help.

[devinemke]

you are describing a classic many-to-many data relationship. you have multiple users who can regsiter for multiple events. this is typically handled by 3 tables: 1 for the users, 1 for the events, and 1 that links them together using the primary keys from the other 2 tables:

users
user_id (INT) PK
name (TEXT)
email (TEXT)

events
event_id (INT) PK
name (TEXT)
location (TEXT)

user_event_links
link_id (INT) PK
user_id (INT)
event_id (INT)

[1042]

devinemke wrote:

you are describing a classic many-to-many data relationship. you have multiple users who can regsiter for multiple events. this is typically handled by 3 tables: 1 for the users, 1 for the events, and 1 that links them together using the primary keys from the other 2 tables:

users
user_id (INT) PK
name (TEXT)
email (TEXT)

events
event_id (INT) PK
name (TEXT)
location (TEXT)

user_event_links
link_id (INT) PK
user_id (INT)
event_id (INT)

ok, so when i add a new event the link to is should also be created? m sorry this is kind of new to me many to many is totally a new word, thanks for the help 🙂

i did found this tutorial

http://www.devtutors.com/tutorial/how-handle-many-many-relationship-php-mysql

is this what you are referring to?

[devinemke]

1042 wrote:

is this what you are referring to?

yes

[1042]

devinemke wrote:

you are describing a classic many-to-many data relationship. you have multiple users who can regsiter for multiple events. this is typically handled by 3 tables: 1 for the users, 1 for the events, and 1 that links them together using the primary keys from the other 2 tables:

users
user_id (INT) PK
name (TEXT)
email (TEXT)

events
event_id (INT) PK
name (TEXT)
location (TEXT)

user_event_links
link_id (INT) PK
user_id (INT)
event_id (INT)

well.. i follow the tutorial on the site i found but didn't make things clear to me, i mean how would all 3 tables be combined for usage? thanks.