Attending Event Script

[offdarip]

I have a local event member system where users can be informed about different events. Users have a member page, etc. I have a list of events and i want users to be able to click on a "attend" link next to the event and the event will show up under their attending events on their member page. Can anyone help me with this or has anyone seen a similar script? Im thinking i will need to setup another mysql table for the events but any help would be greatly appreciated.

[inversesoft123]

http://www.google.com/search?&q=php+events+script

 

There are thousands. East or west google is always best

[paulman888888]

I would add another table maybe prefix_attending

and have these colomns;

id, event_id, user_id, status

 

id = every table needs one

event_id = the event of the id you are adding

user_id =  the user id or username if you dont use id's.

status = I would use codes. For example, 1 = attends,2 = not attending etc. But if you want you could have text.

 

Now for the button. Point to your same page or process page and just enter the information into the database.

 

INSERT INTO prefix_attending SET event_id = $_GET['eid'] and so on

 

Hope i helped abit

Paul

[offdarip]

Thanks paulman88888 for you reply.. I'm not too fluent in php.. I'm working with it trying to get it going tho.. Thanks again