Expert: Hari Priya - 11/21/2009

Question
Hi,
I am building a cinema booking system in ASP/VbScript with MS Access.

I would like to display the records from the recordset in form of:

[-----STAGE-----]

[T] [x] [x] [x] [x]
[x] [x] [T] [x] [x]
[x] [T] [x] [x] [x]
[x] [x] [x] [x] [x]
[x] [x] [x] [x] [x]
[x] [x] [x] [x] [x]

When the query is run, each record is assigned to each “[x]” to the page. But if the record does not exist them I want “[T]” to be shown. (T – taken)

Currently my page has a query string value taken from the previous page, and then the SQL code is run which generates the performance times. Each URL record has a seated assigned to it hence why I want to records to show up like the example above.  

Hope you can help.
Thanks


Answer
Dear Centurion,

I can definitely help you with your cinema booking system. But, you have not given enough information to help you. I do not know how you have stored the records in the table. Each seat is stored as columns or rows? I need the table structure and the sql query you are using, so that I can give the coding example to display the records in a matrix format.

Please post a follow up question with the above mentioned details.

Cheers
Priya