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 ...
23rd September 2009, 05:03 PM #1
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).
IDG Tech News
25th September 2009, 04:05 PM #2
Bummer, I guess it's as hard as I thought then?
By tomdawson in forum Web Development
Last Post: 30th June 2009, 11:29 PM
By DAckroyd in forum Internet Related/Filtering/Firewall
Last Post: 31st March 2009, 11:54 PM
By kerlj001 in forum MIS Systems
Last Post: 15th December 2008, 04:41 PM
By grumpy_git in forum General Chat
Last Post: 16th October 2008, 09:56 PM
By tony82 in forum Virtual Learning Platforms
Last Post: 8th January 2008, 01:49 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)