I?m working on online cinema booking system. User allow to view hall seating plan before proceed to book ticket. Each seat has 3 status- available, reserved and sold represent by 3 different colors. Staff will change the seat status from reserved to sold after customer go to counter to pay for the ticket they had booked online. I?m using ASP and Ms Access.
Question :
i)how to auto update the seat status in database from available to reserve after customer book movie ticket online.
ii)how to display the hall seating plan with the seating status(different colors). Can I do that mainly depend on dreamweaver features or do I need to write my own coding.
Any help would be appreciated
