PDA

View Full Version : Housekeeping Timetable



iUnknown
08-07-2008, 10:44 AM
Hello,

I'm looking for a housekeeping timetable like http://clubhabbo.net/radio/timetable.php
or
http://hffm.co.uk/web/timetable.php

and if possible a backend (admin & dj days) for this.

If anyone has a copy of either of these scripts then please let me know, that'd be great.

I'm not looking for the timetable addon from habboring or the timetable from original/fixed versions of housekeeping.

Moh
08-07-2008, 11:54 AM
Its not hard to code your own, just time consuming.

Create one day, then simply copy and paste (And do a replace all for the date) and there you have it, an all on one page timetable :)

iUnknown
08-07-2008, 12:25 PM
I know it's time consuming, that's the point. I'm coding one from the housekeeping timetable addon (and fixing admin/dj end of it) but if someone has a copy that'll save time.

If anyone has the admin/dj end of the housekeeping timetable addon and it works properly (you can book any day of the week without it mucking up) then that'd be great too.

Jibbish
08-07-2008, 01:59 PM
<?php include('dbConfig.php'); ?>
<style>
table, td, tr{
font-family: Tahoma;
font-size: 11px;
color: #FFFFFF;
text-align: center;
}
</style>
<table width="750" border="0" cellpadding="1" cellspacing="2" bgcolor="#333333" align="center">
<tr>
<td bgcolor="#333333">&nbsp;</td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Monday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Tuesday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Wednesday</strong></div></td>

<td width="91" bgcolor="#333333"><div align="center"><strong>Thursday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Friday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Saturday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Sunday</strong></div></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>00:00 - 01:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>01:00 - 02:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>02:00 - 03:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>03:00 - 04:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>04:00 - 05:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>05:00 - 06:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>06:00 - 07:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>07:00 - 08:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>08:00 - 09:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>

</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>09:00 - 10:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>10:00 - 11:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>11:00 - 12:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>12:00 - 13:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>13:00 - 14:00</strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>14:00 - 15:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>15:00 - 16:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>16:00 - 17:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>17:00 - 18:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>18:00 - 19:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>19:00 - 20:00 </strong></div>

</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>20:00 - 21:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>21:00 - 22:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>22:00 - 23:00 </strong></div>

</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>23:00 - 00:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
</tr>
</table>

Use that as index.php make sure you have added sunday to the timetable SQL


Edited by Hayd93 (Forum Super Moderator): Posts merged due to acctidental double post.

iUnknown
08-07-2008, 02:24 PM
Thanks very much Jake (I think that's your name). +rep :D

Edit: Do you by any chance have the backend for this? Because the copy I have seems to not work well with this... if you book for example 4-5 on admin/dj end it appears as 3-4 on that timetable.

Jibbish
08-07-2008, 02:40 PM
http://images.habboupload.com/1215543456.zip
thats the timetable folder

iUnknown
08-07-2008, 02:46 PM
Same problem, I book 4 - 5 and it appears booked on the public timetable as 3-4.

Jibbish
08-07-2008, 02:49 PM
:s I don't know then because on mine when i book 4 - 5 it comes up as 4 - 5

iUnknown
08-07-2008, 02:53 PM
Could you possibly send me your SQL? That's the only thing that can be different really...

Jibbish
08-07-2008, 03:09 PM
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 08, 2008 at 04:09 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `timetable`
--

-- --------------------------------------------------------

--
-- Table structure for table `friday`
--

CREATE TABLE IF NOT EXISTS `friday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `friday`
--

INSERT INTO `friday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `monday`
--

CREATE TABLE IF NOT EXISTS `monday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `monday`
--

INSERT INTO `monday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `saturday`
--

CREATE TABLE IF NOT EXISTS `saturday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saturday`
--

INSERT INTO `saturday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `status`
--

CREATE TABLE IF NOT EXISTS `status` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `sunday`
--

CREATE TABLE IF NOT EXISTS `sunday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunday`
--

INSERT INTO `sunday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `thursday`
--

CREATE TABLE IF NOT EXISTS `thursday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `thursday`
--

INSERT INTO `thursday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', 'admin', '', '', '', 'admin', '', '', 'admin', '', '', '', '', '', '', 'admin', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `tuesday`
--

CREATE TABLE IF NOT EXISTS `tuesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tuesday`
--

INSERT INTO `tuesday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `wednesday`
--

CREATE TABLE IF NOT EXISTS `wednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wednesday`
--

INSERT INTO `wednesday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

iUnknown
08-07-2008, 03:17 PM
Still same problem, sorry I wasn't clear, I meant it's booking 15:00 - 16:00 when I book 16.00 - 17.00 on the admin.

Edit: Also, try booking 7.00 - 8.00 ;) It books 23 - 24...

Stepheen
08-07-2008, 03:21 PM
You're going to have to rotate the code around so basically the code for 15:00 - 16:00 your gonna have to change that to 16:00 - 17:00 so just swap all the times around by 1 hour.

iUnknown
08-07-2008, 03:26 PM
Just started doing this, it's even more mucked up then it seems. Anyway, I'll do this then post it in this thread when I'm done for anyone who wants it. I'll be editing the public timetable page.

Edit: Done:



<?php include('dbconfig.php'); ?>
<style>
table, td, tr{
font-family: Tahoma;
font-size: 11px;
color: #FFFFFF;
text-align: center;
}
</style>
<table width="750" border="0" cellpadding="1" cellspacing="2" bgcolor="#333333" align="center">
<tr>
<td bgcolor="#333333">&nbsp;</td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Monday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Tuesday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Wednesday</strong></div></td>

<td width="91" bgcolor="#333333"><div align="center"><strong>Thursday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Friday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Saturday</strong></div></td>
<td width="91" bgcolor="#333333"><div align="center"><strong>Sunday</strong></div></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>00:00 - 01:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['a'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>01:00 - 02:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['b'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>02:00 - 03:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['c'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>03:00 - 04:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['d'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>04:00 - 05:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['e'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>05:00 - 06:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['f'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>06:00 - 07:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['g'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>07:00 - 08:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['x'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">

<div align="right"><strong>08:00 - 09:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['h'];
}
?></td>

</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>09:00 - 10:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['i'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>10:00 - 11:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['j'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>11:00 - 12:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['k'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>12:00 - 13:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['l'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>13:00 - 14:00</strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['m'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>14:00 - 15:00 </strong></div>
</div></td>

<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['n'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>15:00 - 16:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['o'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>16:00 - 17:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['p'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>17:00 - 18:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['q'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>18:00 - 19:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['r'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>19:00 - 20:00 </strong></div>

</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['s'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>20:00 - 21:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['t'];
}
?></td>
</tr>
<tr>

<td bgcolor="#333333"><div align="right">
<div align="right"><strong>21:00 - 22:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['u'];
}
?></td>
</tr>
<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>22:00 - 23:00 </strong></div>

</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['v'];
}
?></td>
</tr>

<tr>
<td bgcolor="#333333"><div align="right">
<div align="right"><strong>23:00 - 00:00 </strong></div>
</div></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM monday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM tuesday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM wednesday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM thursday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM friday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM saturday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
<td width="91" align="center" bgcolor="#666666">
<?php
$result = mysql_query("SELECT * FROM sunday");
while($row = mysql_fetch_array($result))
{
echo $row['w'];
}
?></td>
</tr>
</table>

Independent
08-07-2008, 10:11 PM
-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 08, 2008 at 04:09 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `timetable`
--

-- --------------------------------------------------------

--
-- Table structure for table `friday`
--

CREATE TABLE IF NOT EXISTS `friday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `friday`
--

INSERT INTO `friday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `monday`
--

CREATE TABLE IF NOT EXISTS `monday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `monday`
--

INSERT INTO `monday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', 'admin', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `saturday`
--

CREATE TABLE IF NOT EXISTS `saturday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `saturday`
--

INSERT INTO `saturday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `status`
--

CREATE TABLE IF NOT EXISTS `status` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `sunday`
--

CREATE TABLE IF NOT EXISTS `sunday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sunday`
--

INSERT INTO `sunday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `thursday`
--

CREATE TABLE IF NOT EXISTS `thursday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `thursday`
--

INSERT INTO `thursday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', 'admin', '', '', '', 'admin', '', '', 'admin', '', '', '', '', '', '', 'admin', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `tuesday`
--

CREATE TABLE IF NOT EXISTS `tuesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tuesday`
--

INSERT INTO `tuesday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'admin', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `wednesday`
--

CREATE TABLE IF NOT EXISTS `wednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wednesday`
--

INSERT INTO `wednesday` (`id`, `a`, `b`, `c`, `d`, `e`, `f`, `x`, `g`, `h`, `i`, `j`, `k`, `l`, `m`, `n`, `o`, `p`, `q`, `r`, `s`, `t`, `u`, `v`, `w`) VALUES
('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); Would have been nicer if you put it in a spoiler or uploaded a text file..

Want to hide these adverts? Register an account for free!