Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
However I am unsure how to handle this in mysql. I presume I would need to make a field in either table_users or table_events.
e.g. create a field in table_users and store all the id's of the users going to this event. I could then do:
SELECT name from table_users where attendingevent_id='1'
My other problem then is how to store multiple id's in mysql?
I am very confused here so any help to spark my brain would be appreciated.
This gets you around the problem of hacking some way to store multiple user IDs into a single record of one of your existing tables.