Hi all,
I have a page with the date being passed in(calendar_week.php?date=6-4-2005), but what i want to do is display a timetable for the week that date falls on, from 8am-8pm in half-hour increments for each day. If a booking has been made during the particular time increment (eg 9am-10.30am), then this should be displayed in the table.
Bookings will be accessed from the table 'bookings' on a MySQL database 'qubra'. The 'bookings' table contains the fields: id, start_time, end_time, name, description. i would want the 'name' field to be inserted into the timetable, clickable for further details on the booking.
Final output should be something that looks a bit like this if possible:
http://info.wlu.ca/wlu-hp/info/sample_timetable1.jpg
Sorry if it's a bit too time-consuming, but any pointers would be very helpful. I'm a novice to PHP and my mind has been fried over the past couple of days trying to work out how to do this.
Thanks in advance for any help,
Chris