title: Save multiple dates of an event in MySQL
body: <p>I'm building a system that shows "events for this month", listed by day and hour. </p>
  
  <p>When I create the event, I set a start date, an end date and a hour. </p>
  
  <p>Let's say that one event starts at 07-10-2011 and ends 07-12-2011. The problem is that some days in this date range will not feature the event. As an example, this event may happen all days and at the same hour, except some few days where it will not happen or has a different hour (think about a show with an opening date different than the rest of the days).</p>
  
  <p>I'm using PHP, MySQL and Codeigniter and my doubt is about the right way to save those dates in the database. Another table with all the dates and the event ID, or save them all in a field inside the event row? Or something else?</p>
  
  <p>Thanks</p>