Output timetable from SQL data?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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:

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,


Site Timeline