+ Post New Thread
Results 1 to 2 of 2
Web Development Thread, MRBS: Display rooms available for current lesson in Coding and Web Development; I created a unique "home" page for our MRBS with some links to the most used features and a list ...
  1. #1
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37

    MRBS: Display rooms available for current lesson

    I created a unique "home" page for our MRBS with some links to the most used features and a list of the next 5 bookings for the user.

    I want to make a new table which shows all the rooms/resources for the current period, and whether it is booked or available. Looking at how the database deals with entries and times, there is only a difference of 60 between starttime and endtime (this works out at 60 seconds, not 60 minutes). I have being trying to use the DATE(U) variable to try and work out how to extract just the entries for this lesson, but I am struggling! Any ideas how to do this?

    I have it set up so that there are periods 1-5, then an after school entry (so only 6 slots in each day).

  2. #2
    dgsmith's Avatar
    Join Date
    Nov 2007
    Location
    Merseyside, England
    Posts
    1,111
    Thank Post
    119
    Thanked 90 Times in 78 Posts
    Rep Power
    37
    Bummer, I guess it's as hard as I thought then?



SHARE:
+ Post New Thread

Similar Threads

  1. PHP: Display current URL
    By tomdawson in forum Web Development
    Replies: 5
    Last Post: 30th June 2009, 11:29 PM
  2. Turning internet on/off for IT Rooms
    By DAckroyd in forum Internet Related/Filtering/Firewall
    Replies: 8
    Last Post: 31st March 2009, 11:54 PM
  3. Replies: 8
    Last Post: 15th December 2008, 04:41 PM
  4. Supervision of IT rooms?
    By grumpy_git in forum General Chat
    Replies: 12
    Last Post: 16th October 2008, 09:56 PM
  5. Moving Rooms in Fronter
    By tony82 in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 8th January 2008, 01:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •