title: Creating DB For online ticket booking System
body: <p>I have to design an online ticket booking system as a part of my project. I have problems with implementation for advance booking concept. Currently I just use different tables and have a status column to see if it is booked or not and just display them with differnt image src by echoing in <code>PHP</code>. I use <code>MySQL</code> DB.</p>
  
  <p>Please help me with your ideas to maintain booking for 4 screens(4 shows each) and DB to maintain advance booking after the admin Schedules booking for a corresponding date/dates.</p>