Officially driving me insane now; best way to do a DJ Timetable

[lolwut]

Right well yeah, I've already got a DJ panel done, well basically all done, it's missing a Timetable.
I've been trying for a good few hours now and it's mind numbingly boring.

Have any of you got any good ideas for how I could make a Timetable?
My idea for it sucks and doesn't work.
Any suggestions would be appreciated.

[rh4u]

use a table and echo the information from the db?

[lolwut]

Very smart.
What I was hoping for is ideas for the best methods to do that, I know how to code the PHP, but I'm wondering how best to lay out the SQL for ease of use and how to lay out the actual timetable pages.

[rh4u]

Very smart.

That was sarcasm right?

[lolwut]

Unfortunatley, yes.
Still needing ideas for this.

[Snex]

I like the way that airhabbo have done it etc. with the one table as it means thet you don't have to reload the page which makes it easier for the viewer.

[Invent]

Two popular ways.

AJAX:
http://79.64.232.202/powerpanel/frontend/timetable/

NON-AJAX:
http://79.64.232.202/powerpanel/fron...able/habbo.php

[L!nK]

Two popular ways.

AJAX:
http://79.64.232.202/powerpanel/frontend/timetable/

NON-AJAX:
http://79.64.232.202/powerpanel/fron...able/habbo.php

Ohh Ajax version is nice

[Beau]

I can tell you now, unless you're using array loops, which I've NEVER got the hang of, it's a lot of hardcoding.

I've recently recoded the backend for HabboHut, which includes a schedule system. I have a table on the database called 'schedule'. Inside, there are 25 columns. One for day, and one for every hour of the day (I've called them 'hour_12' (for 12pm as an example), as MySQL won't work properly with columns beginning with numbers. Inside the table, I have seven rows, one for every day of the week. The day column is filled with the day (eg. Monday, Tuesday, Wednesday).

When I'm booking a new slot, I'll grab the day and hour the user is booking, and slot it in like so:

$query = "UPDATE schedule SET $hour='$djname' WHERE day='$day'";
$query = mysql_query($query); 

Returning the data in a timetable is the really annoying part. I've got it set up as a table, where each cell is returning a piece from the database. Eg.

$query = "SELECT * FROM schedule WHERE day='Tuesday'";
$query = mysql_query($query);
$tuesday = mysql_fetch_assoc($query);

echo $tuesday['hour_9']; // Will echo the slot booked for 9am on Tuesday 

Unfortunately, this means entering a code echoing the data in each cell of the timetable = 168 rows, which is a lot of hardcoding. I pondered this issue for ages, and it seemed to be the only way to do it. Took me an hour and a half, but it's done now!

[Invent]

I can tell you now, unless you're using array loops, which I've NEVER got the hang of, it's a lot of hardcoding.

Timetables are quite easy to code :S

I made mine in like 10 Minutes. Including the AJAX controls. (Changing days, etc).