Hey Guys,
I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" table by week day (like Wednesday).
I can display events and default events fine based on date or day, but I have a "limited_spots" field in the default_events table used for allowing only so many people to rsvp for that default event. So lets say a default event that happens every Monday is supposed to show 50 spots, then it is down to 1 spot left by the end of the day. Next Monday I need the spots to be back up to 50 and to remove the event participants from the guest list.
How should this be done? Also, yes I am a noob. Any help would be greatly appreciated, thanks!
- Drew