So I'm making an event system. I have coded it all myself (except for a sql schema from sean).
Heres my table setup for MySQL (relevant to my question[s]):
users -> id | username | class | level | guild
events -> id | event_name | event_time
event_apps -> id | event_id | applicant_id
That is what I have so far.
I want to make it so that in the first image, when people apply, that it shows how many people have applied on the main list as well as if the logged in user has applied ("applied" blank) in the state column.
In the 2nd image, I have all the event details and a list underneath them that I would like to populate with all the users that have applied.
In the end, it should look something like:
So here's a checklist of things I need to do:
-Check how many people (members and 'randoms') that are signed up for an event then display it as number (Like the count() function.)
-Check to see if the user is applied for an event. If they are, display 'Applied' in the event list.
-List all of the people enrolled in a single event. (separate tables for members and randoms)
-Reoccurring events: Delete events from MySQL table after event is finished and make a new event for the next day. (if that makes sense)
, Dec 29th, 2012 @ 5:29 pm