Jump to content

Small problem...


xyn

Recommended Posts

Hey guys,
I'm trying to make a timetable for a DJ Panel. where
the DJ logs in they can BOOK a slot from the current
day upto the end of the week (sun)

I've got a small problem with this though, Basically it
has been separated in 24 slots, (hour slots) and i need
to check if the slot has been taken, iof not then show
a link where any dj can clickto book.

My problem, I am NOT sure how to...
1. Design the database table for this method.
2. How to check it's been taken or not (to book it's inserted)
3. How to out-put the links...

My code:
[code=php:0]
<?PHP
//require("Session.php");
$day = $_GET['day'];
if(!$day){$day="Monday"; $date="mon";}
elseif($day == "mon"){$day="Monday"; $date="mon";}
elseif($day == "tue"){$day="Tuesday"; $date="tue";}
elseif($day == "wed"){$day="Wednesday"; $date="wed";}
elseif($day == "thu"){$day="Thursday"; $date="thu";}
elseif($day == "fri"){$day="Friday"; $date="fri";}
elseif($day == "sat"){$day="Saturday"; $date="sat";}
elseif($day == "sun"){$day="Sunday"; $date="sun";}
else{$day="Monday"; $date="mon";}

$SQL = mysql_query("SELECT * FROM ttbl WHERE day='".strtolower($date)."'");
$booked = mysql_num_rows($SQL);

?>
<div align="center">
  <center>
  <table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#487CB0" width="450">
    <tr>
      <td width="100%">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="448">
        <tr>
          <td width="448" bgcolor="#487CB0" height="22">
          <p align="left"><b><font face="Verdana" size="2" color="#E6E6E6">&nbsp;<a href="index.php?x=timetable&day=mon"><font color="#FFFF00">Mon</font></a>
          &middot; <a href="index.php?x=timetable&day=tue"><font color="#FFFF00">Tue</font></a>
          &middot; <a href="index.php?x=timetable&day=wed"><font color="#FFFF00">Wed</font></a>
          &middot; <a href="index.php?x=timetable&day=thu"><font color="#FFFF00">Thu</font></a>
          &middot; <a href="index.php?x=timetable&day=fri"><font color="#FFFF00">Fri</font></a>
          &middot; <a href="index.php?x=timetable&day=sat"><font color="#FFFF00">Sat</font></a>
          &middot; <a href="index.php?x=timetable&day=sun"><font color="#FFFF00">Sun</font></a></font></b></p>
          </td>
        </tr>
        <tr>
          <td width="448" height="1"></td>
        </tr>
        <tr>
          <td width="448" bgcolor="#9FBBD9">
          <?php
          $query = mysql_query("SELECT slot,user FROM ttbl WHERE day='".strtolower($date)."'");
          while($row = mysql_fetch_array($query, MYSQL_NUM))
          {
          $Slot = $row[0];
          $User = $row[1];
          if($Slot == "1" && $Slot == "") { $s1="available"; }else{ $s1="unavailable"; }
          if($Slot == "2" && $Slot == "") { $s2="available"; }else{ $s2="unavailable"; }
          if($Slot == "3" && $Slot == "") { $s3="available"; }else{ $s3="unavailable"; }
          if($Slot == "4" && $Slot == "") { $s4="available"; }else{ $s4="unavailable"; }
          if($Slot == "5" && $Slot == "") { $s5="available"; }else{ $s5="unavailable"; }
          if($Slot == "6" && $Slot == "") { $s6="available"; }else{ $s6="unavailable"; }
          if($Slot == "7" && $Slot == "") { $s7="available"; }else{ $s7="unavailable"; }
          if($Slot == "8" && $Slot == "") { $s8="available"; }else{ $s8="unavailable"; }
          if($Slot == "9" && $Slot == "") { $s9="available"; }else{ $s9="unavailable"; }
          if($Slot == "10" && $Slot == "") { $s10="available"; }else{ $s10="unavailable"; }
          if($Slot == "11" && $Slot == "") { $s11="available"; }else{ $s11="unavailable"; }
          if($Slot == "12" && $Slot == "") { $s12="available"; }else{ $s12="unavailable"; }
          if($Slot == "13" && $Slot == "") { $s13="available"; }else{ $s13="unavailable"; }
          if($Slot == "14" && $Slot == "") { $s14="available"; }else{ $s14="unavailable"; }
          if($Slot == "15" && $Slot == "") { $s15="available"; }else{ $s15="unavailable"; }
          if($Slot == "16" && $Slot == "") { $s16="available"; }else{ $s16="unavailable"; }
          if($Slot == "17" && $Slot == "") { $s17="available"; }else{ $s17="unavailable"; }
          if($Slot == "18" && $Slot == "") { $s18="available"; }else{ $s18="unavailable"; }
          if($Slot == "19" && $Slot == "") { $s19="available"; }else{ $s19="unavailable"; }
          if($Slot == "20" && $Slot == "") { $s20="available"; }else{ $s20="unavailable"; }
          if($Slot == "21" && $Slot == "") { $s21="available"; }else{ $s21="unavailable"; }
          if($Slot == "22" && $Slot == "") { $s22="available"; }else{ $s22="unavailable"; }
          if($Slot == "23" && $Slot == "") { $s23="available"; }else{ $s23="unavailable"; }
          if($Slot == "24" && $Slot == "") { $s24="available"; }else{ $s24="unavailable"; }
        }
       
          echo ('
          <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="448">
            <tr>
              <td width="100%" height="20" colspan="2">
              &nbsp;<font face="Verdana" size="1">There are <b>'.$booked.'</b> booked
              slots for <b>'.$day.'</b>.</font></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><b><font face="Verdana" size="1">Time Slot</font></b></td>
              <td width="50%" height="20">
              <p align="center"><b><font face="Verdana" size="1">Availability</font></b></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">00:01&nbsp; -&nbsp;
              01:00</font></td>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">'.$s1.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">01:01&nbsp; -&nbsp;
              02:00</font></td>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">'.$s2.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <p align="center"><font face="Verdana" size="1">02:01&nbsp; -&nbsp;
              03:00</font></td>
              <td width="50%" height="20" align="center">
              <p align="center"><font face="Verdana" size="1">'.$s3.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">03:01&nbsp; -&nbsp; 04:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s4.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">04:01&nbsp; -&nbsp; 05:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s5.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">05:01&nbsp; -&nbsp; 06:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s6.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">06:01&nbsp; -&nbsp; 07:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s7.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">07:01&nbsp; -&nbsp; 08:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s8.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">08:01&nbsp; -&nbsp; 09:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s9.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">09:01&nbsp; -&nbsp; 10:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s10.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">10:01&nbsp; -&nbsp; 11:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s11.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">11:01&nbsp; -&nbsp; 12:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s12.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">12:01&nbsp; -&nbsp; 13:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s13.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">13:01&nbsp; -&nbsp; 14:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s14.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">14:01&nbsp; -&nbsp; 15:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s15.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">15:01&nbsp; -&nbsp; 16:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s16.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">16:01&nbsp; -&nbsp; 17:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s17.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">17:01&nbsp; -&nbsp; 18:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s18.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">18:01&nbsp; -&nbsp; 19:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s19.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">19:01&nbsp; -&nbsp; 20:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s20.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">20:01&nbsp; -&nbsp; 21:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s21.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">21:01&nbsp; -&nbsp; 22:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s22.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">22:01&nbsp; -&nbsp; 23:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s23.'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">23:01&nbsp; -&nbsp; 00:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s24.'</font></td>
            </tr>');
            ?>
          </table>
          </td>
        </tr>
        </table>
      </td>
    </tr>
  </table>
  </center>
</div>
[/code]
Link to comment
https://forums.phpfreaks.com/topic/28234-small-problem/
Share on other sites

How your code is written here the slots will always be unavailable

[quote author=xyn link=topic=116040.msg472603#msg472603 date=1164290762]
<?php
          if($Slot == "1" && $Slot == "") { $s1="available"; }else{ $s1="unavailable"; }
          if($Slot == "2" && $Slot == "") { $s2="available"; }else{ $s2="unavailable"; }
          if($Slot == "3" && $Slot == "") { $s3="available"; }else{ $s3="unavailable"; }
          if($Slot == "4" && $Slot == "") { $s4="available"; }else{ $s4="unavailable"; }
          if($Slot == "5" && $Slot == "") { $s5="available"; }else{ $s5="unavailable"; }
          if($Slot == "6" && $Slot == "") { $s6="available"; }else{ $s6="unavailable"; }
          if($Slot == "7" && $Slot == "") { $s7="available"; }else{ $s7="unavailable"; }
          if($Slot == "8" && $Slot == "") { $s8="available"; }else{ $s8="unavailable"; }
          if($Slot == "9" && $Slot == "") { $s9="available"; }else{ $s9="unavailable"; }
          if($Slot == "10" && $Slot == "") { $s10="available"; }else{ $s10="unavailable"; }
          if($Slot == "11" && $Slot == "") { $s11="available"; }else{ $s11="unavailable"; }
          if($Slot == "12" && $Slot == "") { $s12="available"; }else{ $s12="unavailable"; }
          if($Slot == "13" && $Slot == "") { $s13="available"; }else{ $s13="unavailable"; }
          if($Slot == "14" && $Slot == "") { $s14="available"; }else{ $s14="unavailable"; }
          if($Slot == "15" && $Slot == "") { $s15="available"; }else{ $s15="unavailable"; }
          if($Slot == "16" && $Slot == "") { $s16="available"; }else{ $s16="unavailable"; }
          if($Slot == "17" && $Slot == "") { $s17="available"; }else{ $s17="unavailable"; }
          if($Slot == "18" && $Slot == "") { $s18="available"; }else{ $s18="unavailable"; }
          if($Slot == "19" && $Slot == "") { $s19="available"; }else{ $s19="unavailable"; }
          if($Slot == "20" && $Slot == "") { $s20="available"; }else{ $s20="unavailable"; }
          if($Slot == "21" && $Slot == "") { $s21="available"; }else{ $s21="unavailable"; }
          if($Slot == "22" && $Slot == "") { $s22="available"; }else{ $s22="unavailable"; }
          if($Slot == "23" && $Slot == "") { $s23="available"; }else{ $s23="unavailable"; }
          if($Slot == "24" && $Slot == "") { $s24="available"; }else{ $s24="unavailable"; }
        }
?php
[/quote]

$Slot can't be filled with an integer and an empty string at the same time.
Change this to

[code]
<?php
  if($Slot == "xx" && $User == "") { .... } else { ... }

  // Shorter notation
  $sXX = ($Slot == "xx" && $User == "") ? "available" : "unavailable";
?>
[/code]

You are also doing this inside a loop so why don't use a counter instead of writing all these lines manually ?

[code]
<?php
$counter = 1;
$s = array();
while($row = mysql_fetch_array($query, MYSQL_NUM)) {
  $s[$counter] = ($Slot = "$counter" && $User == "") ? 'available' : 'unavailable'';
}
?>
[/code]

And you can do this aswell for outputting your table:

[code]
<?php
$output = <<<HTML
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="448">
  <tr>
    <td width="100%" height="20" colspan="2">
      &nbsp;<font face="Verdana" size="1">There are <b>'.$booked.'</b> booked
      slots for <b>'.$day.'</b>.</font>
    </td>
</tr>
HTML;
for($i = 1; $i < count($s); $i++) {
  $h = $i-1;
  $output .= <<<HTML
    <tr>
      <td width="50%" height="20">
        <p align="center"><font face="Verdana" size="1">$h:01&nbsp; -&nbsp;
          $i:00</font></td>
      <td width="50%" height="20">
        <p align="center"><font face="Verdana" size="1">$s[$i]</font></td>
    </tr>
HTML;
}

$output .= <<<HTML
  </table>
HTML;

echo $output;
?>
[/code]
Link to comment
https://forums.phpfreaks.com/topic/28234-small-problem/#findComment-129162
Share on other sites

Hi,
I designed database and revised some of your code.
I thought it better if you store day in DATE format.

Database:
[code]
CREATE TABLE `ttbl` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`date` DATE NOT NULL ,
`slot` INT( 2 ) NOT NULL ,
`user` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ,
UNIQUE (
`date` ,
`slot`
)
) ENGINE = MYISAM ;
[/code]

PHP code :
[code]
<?PHP
//require("Session.php");

//Define timestamp for Monday of this week
//if Today is not Monday, then Monday of this week is last monday
$dayofweek = date("w");
if($dayofweek > 0){
$thismonday = strtotime("last Monday");
}else{
$thismonday = strtotime("next Monday");
}



$day = $_GET['day'];
if(!$day){$day="Monday"; $date=date("Y-m-d",$thismonday);}
elseif($day == "mon"){$day="Monday"; $date=date("Y-m-d",$thismonday);}
elseif($day == "tue"){$day="Tuesday"; $date=date("Y-m-d",strtotime(" +1 day",$thismonday));}
elseif($day == "wed"){$day="Wednesday"; $date=date("Y-m-d",strtotime(" +2 days",$thismonday));}
elseif($day == "thu"){$day="Thursday"; $date=date("Y-m-d",strtotime(" +3 days",$thismonday));}
elseif($day == "fri"){$day="Friday"; $date=date("Y-m-d",strtotime(" +4 days",$thismonday));}
elseif($day == "sat"){$day="Saturday"; $date=date("Y-m-d",strtotime(" +5 days",$thismonday));}
elseif($day == "sun"){$day="Sunday"; $date=date("Y-m-d",strtotime(" +6 days",$thismonday));}
else{$day="Monday"; $date=date("Y-m-d",$thismonday);}

// Connecting, selecting database
$link = mysql_connect('localhost', 'root', '')
  or die('Could not connect: ' . mysql_error());
mysql_select_db('test') or die('Could not select database');

$SQL = mysql_query("SELECT * FROM ttbl WHERE date='".strtolower($date)."'");
$booked = mysql_num_rows($SQL);

//insert booking data
if($_GET['book']=="true"){
mysql_query("INSERT INTO `ttbl` ( `date` , `slot` , `user` ) VALUES ( '$date', '$_GET[slot]', 'user');")  or die('Could not insert data: ' . mysql_error());;
header("Location: $_SERVER[PHP_SELF]?day=$_GET[day]");
}
//end of insert booking data
?>
<div align="center">
  <center>
  <table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#487CB0" width="450">
    <tr>
      <td width="100%">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="448">
        <tr>
          <td width="448" bgcolor="#487CB0" height="22">
          <p align="left"><b><font face="Verdana" size="2" color="#E6E6E6">&nbsp;<a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=mon"><font color="#FFFF00">Mon</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=tue"><font color="#FFFF00">Tue</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=wed"><font color="#FFFF00">Wed</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=thu"><font color="#FFFF00">Thu</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=fri"><font color="#FFFF00">Fri</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=sat"><font color="#FFFF00">Sat</font></a>
          &middot; <a href="<?=$_SERVER['PHP_SELF']; ?>?x=timetable&day=sun"><font color="#FFFF00">Sun</font></a></font></b></p>
          </td>
        </tr>
        <tr>
          <td width="448" height="1"></td>
        </tr>
        <tr>
          <td width="448" bgcolor="#9FBBD9">
          <?php
          $query = mysql_query("SELECT slot,user FROM ttbl WHERE date='".strtolower($date)."'");
          while($row = mysql_fetch_array($query, MYSQL_NUM))
          {
  $Slot = $row[0];
  $s_flag[$Slot] = true;
        }

for($i=1; $i<=24; $i++){
if(isset($s_flag[$i])){
$s[$i] = 'Not Available';
}else{
$s[$i] = "<a href=\"$_SERVER[PHP_SELF]?book=true&slot=$i&day=$_GET[day]\">Available</a>";
}
}




          echo ('
          <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="448">
            <tr>
              <td width="100%" height="20" colspan="2">
              &nbsp;<font face="Verdana" size="1">There are <b>'.$booked.'</b> booked
              slots for <b>'.$day.'</b>.</font></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><b><font face="Verdana" size="1">Time Slot</font></b></td>
              <td width="50%" height="20">
              <p align="center"><b><font face="Verdana" size="1">Availability</font></b></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">00:01&nbsp; -&nbsp;
              01:00</font></td>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">'.$s[1].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">01:01&nbsp; -&nbsp;
              02:00</font></td>
              <td width="50%" height="20">
              <p align="center"><font face="Verdana" size="1">'.$s[2].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <p align="center"><font face="Verdana" size="1">02:01&nbsp; -&nbsp;
              03:00</font></td>
              <td width="50%" height="20" align="center">
              <p align="center"><font face="Verdana" size="1">'.$s[3].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">03:01&nbsp; -&nbsp; 04:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[4].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">04:01&nbsp; -&nbsp; 05:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[5].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">05:01&nbsp; -&nbsp; 06:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[6].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">06:01&nbsp; -&nbsp; 07:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[7].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">07:01&nbsp; -&nbsp; 08:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[8].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">08:01&nbsp; -&nbsp; 09:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[9].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">09:01&nbsp; -&nbsp; 10:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[10].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">10:01&nbsp; -&nbsp; 11:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[11].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">11:01&nbsp; -&nbsp; 12:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[12].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">12:01&nbsp; -&nbsp; 13:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[13].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">13:01&nbsp; -&nbsp; 14:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[14].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">14:01&nbsp; -&nbsp; 15:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[15].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">15:01&nbsp; -&nbsp; 16:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[16].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">16:01&nbsp; -&nbsp; 17:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[17].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">17:01&nbsp; -&nbsp; 18:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[18].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">18:01&nbsp; -&nbsp; 19:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[19].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">19:01&nbsp; -&nbsp; 20:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[20].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">20:01&nbsp; -&nbsp; 21:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[21].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">21:01&nbsp; -&nbsp; 22:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[22].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">22:01&nbsp; -&nbsp; 23:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[23].'</font></td>
            </tr>
            <tr>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">23:01&nbsp; -&nbsp; 00:00</font></td>
              <td width="50%" height="20" align="center">
              <font face="Verdana" size="1">'.$s[24].'</font></td>
            </tr>');
            ?>
          </table>
          </td>
        </tr>
        </table>
      </td>
    </tr>
  </table>
  </center>
</div>
[/code]

Hope it useful for you.
Link to comment
https://forums.phpfreaks.com/topic/28234-small-problem/#findComment-129224
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.