-
Housekeeping Timetable
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.
-
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 :)
-
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.
-
PHP Code:
<?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"> </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.
-
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.
-
-
Same problem, I book 4 - 5 and it appears booked on the public timetable as 3-4.
-
:s I don't know then because on mine when i book 4 - 5 it comes up as 4 - 5
-
Could you possibly send me your SQL? That's the only thing that can be different really...
-
-- 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', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');