CepAcegegow
New Member
I'm working on an event calendar, using MySQL and PHP.I already set up a table with the dates and hours and the calendar works pretty well. I have to make an event calendar for multiple rooms, so I was thinking I would have to create a table for every new room that is added to the DB. Considering my calendar is divided by intervals of half and hour, my index column goes like this: \[code\]2010-1-1 00:00:00\[/code\], \[code\]2010-1-1 00:30:00\[/code\], \[code\]2010-1-1 01:00:00\[/code\] and so on, for about 25 years into the future. Also there's another column with the event ID.I think it would take too much time, as well as space, everytime I add a room, because a new HUGE table would have to be created. Is there a simpler approach for this?