Printable View
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.
Use that as index.php make sure you have added sunday to the timetable SQLPHP 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>
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.
http://images.habboupload.com/1215543456.zip
thats the timetable folder
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', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
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...
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.
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:
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['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>
Would have been nicer if you put it in a spoiler or uploaded a text file..
