Output timetable from SQL data?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Chris Rodgerson

    Output timetable from SQL data?

    Hi all,

    I have a page with the date being passed
    in(calendar_wee k.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,

    Chris




Working...