[Akshay5233]

i m working on multiplex management system
so my question is suppose i have a screen there are 50 seats in which suppose 4 seats are book 4,5,6 & 7
so i have taken seats as label when i click on label i'ts back color changes but 1)how do i store it's value to database
2)when i open a screen booked seats must be there

[modi123_1]

Quote

so i have taken seats as label when i click on label i'ts back color changes but 1)how do i store it's value to database

Typically you would have a few tables.. one table being for the theater/screen ids.. one would be for what movie is playing on what screen (and time).. then a table of 'tickets purchased'.. which would hold a seat id and a theater id and movie/time id.

Though I am not sure why you would track seat numbers.. I mean I have never been to a movie with assigned seating.

Quote

2)when i open a screen booked seats must be there

It's a pretty straight forward select statement. We have great tutorials about DB interaction in the..ah.. well.. tutorial section.

[C.Andrews]

modi123_1, on 10 January 2013 - 08:07 AM, said:

Though I am not sure why you would track seat numbers.. I mean I have never been to a movie with assigned seating.

I hadn't heard about these either until I was in Houston, TX for a business meeting and went to the Sundance Cinema. They have this little touchscreen ticket-buying thing and you can see what seats are taken and stake out a claim right there in the lobby. It's kinda neat.