?><?php include("connect.php"); $day = $_GET['week']; if($_GET['week'] == ""){ $day = date("l"); $_GET['week'] = date("l"); } $result = mysql_query("SELECT * FROM rp_timetable WHERE day = '$day'"); while($slot = mysql_fetch_assoc($result)) { if($slot["1"] == "") { $one = "OPEN SLOT"; } else { $one = "<b>DJ {$slot["1"]}</b>"; } if($slot["2"] == "") { $two = "OPEN SLOT"; } else { $two = "<b>DJ {$slot["2"]}</b>"; } if($slot["3"] == "") { $three = "OPEN SLOT"; } else { $three = "<b>DJ {$slot["3"]}</b>"; } if($slot["4"] == "") { $four = "OPEN SLOT"; } else { $four = "<b>DJ {$slot["4"]}</b>"; } if($slot["5"] == "") { $five = "OPEN SLOT"; } else { $five = "<b>DJ {$slot["5"]}</b>"; } if($slot["6"] == "") { $six = "OPEN SLOT"; } else { $six = "<b>DJ {$slot["6"]}</b>"; } if($slot["7"] == "") { $seven = "OPEN SLOT"; } else { $seven = "<b>DJ {$slot["7"]}</b>"; } if($slot["8"] == "") { $eight = "OPEN SLOT"; } else { $eight = "<b>DJ {$slot["8"]}</b>"; } if($slot["9"] == "") { $nine = "OPEN SLOT"; } else { $nine = "<b>DJ {$slot["9"]}</b>"; } if($slot["10"] == "") { $ten = "OPEN SLOT"; } else { $ten = "<b>DJ {$slot["10"]}</b>"; } if($slot["11"] == "") { $eleven = "OPEN SLOT"; } else { $eleven = "<b>DJ {$slot["11"]}</b>"; } if($slot["12"] == "") { $twelve = "OPEN SLOT"; } else { $twelve = "<b>DJ {$slot["12"]}</b>"; } if($slot["13"] == "") { $thirteen = "OPEN SLOT"; } else { $thirteen = "<b>DJ {$slot["13"]}</b>"; } if($slot["14"] == "") { $fourteen = "OPEN SLOT"; } else { $fourteen = "<b>DJ {$slot["14"]}</b>"; } if($slot["15"] == "") { $fifteen = "OPEN SLOT"; } else { $fifteen = "<b>DJ {$slot["15"]}</b>"; } if($slot["16"] == "") { $sixteen = "OPEN SLOT"; } else { $sixteen = "<b>DJ {$slot["16"]}</b>"; } if($slot["17"] == "") { $seventeen = "OPEN SLOT"; } else { $seventeen = "<b>DJ {$slot["17"]}</b>"; } if($slot["18"] == "") { $eighteen = "OPEN SLOT"; } else { $eighteen = "<b>DJ {$slot["18"]}</b>"; } if($slot["19"] == "") { $nineteen = "OPEN SLOT"; } else { $nineteen = "<b>DJ {$slot["19"]}</b>"; } if($slot["20"] == "") { $twenty = "OPEN SLOT"; } else { $twenty = "<b>DJ {$slot["20"]}</b>"; } if($slot["21"] == "") { $twentyone = "OPEN SLOT"; } else { $twentyone = "<b>DJ {$slot["21"]}</b>"; } if($slot["22"] == "") { $twentytwo = "OPEN SLOT"; } else { $twentytwo = "<b>DJ {$slot["22"]}</b>"; } if($slot["23"] == "") { $twentythree = "OPEN SLOT"; } else { $twentythree = "<b>DJ {$slot["23"]}</b>"; } if($slot["24"] == "") { $twentyfour = "OPEN SLOT"; } else { $twentyfour = "<b>DJ {$slot["24"]}</b>"; } $day = $_GET['week']; echo "<div id='timetable_pub'><center>"; $result = mysql_query("SELECT sitename FROM rp_data"); while($row = mysql_fetch_assoc($result)) { echo "<u>".$row['sitename']." Radio Timetable</u><p>"; } echo "<h1>-You are currently viewing "; echo "$day"; echo "'s timetable-</h1><p>"; echo "<a href='?week=Monday'>Monday</a> | <a href='?week=Tuesday'>Tuesday</a> | <a href='?week=Wednesday'>Wednesday</a> | <a href='?week=Thursday'>Thursday</a> | <a href='?week=Friday'>Friday</a> | <a href='?week=Saturday'>Saturday</a> | <a href='?week=Sunday'>Sunday</a><br><hr><br> <table border='0' valign='middle' align='center'> <tr> <td width='150px' align='center'><u>Time</u></td> <td width='150px' align='center'><u>DJ Booked</u><td> </tr> <tr> <td width='150px' align='center'>12:00 - 01:00 AM</td> <td width='150px' align='center'>$one<td> </tr> <tr> <td width='150px' align='center'>01:00 - 02:00 AM</td> <td width='150px' align='center'>$two<td> </tr> <tr> <td width='150px' align='center'>02:00 - 03:00 AM</td> <td width='150px' align='center'>$three<td> </tr> <tr> <td width='150px' align='center'>03:00 - 04:00 AM</td> <td width='150px' align='center'>$four<td> </tr> <tr> <td width='150px' align='center'>04:00 - 05:00 AM</td> <td width='150px' align='center'>$five<td> </tr> <tr> <td width='150px' align='center'>05:00 - 06:00 AM</td> <td width='150px' align='center'>$six<td> </tr> <tr> <td width='150px' align='center'>06:00 - 07:00 AM</td> <td width='150px' align='center'>$seven<td> </tr> <tr> <td width='150px' align='center'>07:00 - 08:00 AM</td> <td width='150px' align='center'>$eight<td> </tr> <tr> <td width='150px' align='center'>08:00 - 09:00 AM</td> <td width='150px' align='center'>$nine<td> </tr> <tr> <td width='150px' align='center'>09:00 - 10:00 AM</td> <td width='150px' align='center'>$ten<td> </tr> <tr> <td width='150px' align='center'>10:00 - 11:00 AM</td> <td width='150px' align='center'>$eleven<td> </tr> <tr> <td width='150px' align='center'>11:00 - 12:00 AM</td> <td width='150px' align='center'>$twelve<td> </tr> <tr> <td width='150px' align='center'>12:00 - 01:00 PM</td> <td width='150px' align='center'>$thirteen<td> </tr> <tr> <td width='150px' align='center'>01:00 - 02:00 PM</td> <td width='150px' align='center'>$fourteen<td> </tr> <tr> <td width='150px' align='center'>02:00 - 03:00 PM</td> <td width='150px' align='center'>$fifteen<td> </tr> <tr> <td width='150px' align='center'>03:00 - 04:00 PM</td> <td width='150px' align='center'>$sixteen<td> </tr> <tr> <td width='150px' align='center'>04:00 - 05:00 PM</td> <td width='150px' align='center'>$seventeen<td> </tr> <tr> <td width='150px' align='center'>05:00 - 06:00 PM</td> <td width='150px' align='center'>$eighteen<td> </tr> <tr> <td width='150px' align='center'>06:00 - 07:00 PM</td> <td width='150px' align='center'>$nineteen<td> </tr> <tr> <td width='150px' align='center'>07:00 - 08:00 PM</td> <td width='150px' align='center'>$twenty<td> </tr> <tr> <td width='150px' align='center'>08:00 - 09:00 PM</td> <td width='150px' align='center'>$twentyone<td> </tr> <tr> <td width='150px' align='center'>09:00 - 10:00 PM</td> <td width='150px' align='center'>$twentytwo<td> </tr> <tr> <td width='150px' align='center'>10:00 - 11:00 PM</td> <td width='150px' align='center'>$twentythree<td> </tr> <tr> <td width='150px' align='center'>11:00 - 12:00 PM</td> <td width='150px' align='center'>$twentyfour<td> </tr> <tr> <td width='150px' align='center'>$day</td> <td width='150px' align='center'></td> </tr> </table> </center><p></div>"; } ?>