i learned php, mysql and css from w3schools and designed my personal website www.sikki.in
and got stuck-ed at complex part of designing cinema online ticket reservation system to multiple located screens for exhibitor and producer.
i am using php and mysql for Back end, but problem in designing Front end system like generating seats dynamically and mapping seats with rows and column
please assistance in making a "how to" for this
details :
in screen table all the particulars of screen will present like no. of classes in screen, no. seats in each class, screen location, ticket price etc
booking table will have all the details of ticket booking details like movie name, screen name, show date, show time, booking status, reserved by(exhibitor username) etc
seats table will have all the details of screen_id, no_rows now of columns