displaying records horizontally?

Author Message
centurion

  • Total Posts : 3
  • Scores: 0
  • Reward points : 0
  • Joined: 11/22/2009
  • Status: offline
displaying records horizontally? Sunday, November 22, 2009 4:46 AM (permalink)
0
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-----]
 
 
[x] [x] [x]
 
[x] [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 to be shown. (B – Booked)
 
 
 
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
<message edited by centurion on Sunday, November 22, 2009 4:48 AM>
 
#1
    centurion

    • Total Posts : 3
    • Scores: 0
    • Reward points : 0
    • Joined: 11/22/2009
    • Status: offline
    Re:displaying records horizontally? Sunday, November 22, 2009 4:49 AM (permalink)
    0
    if its booked then instead of a X in the box, i want a capital letter B.

    hope that makes sense.
     
    #2

      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 1 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2012 ASPPlayground.NET Forum Version 3.9