Date and time problem

[feichter]

Perhaps someone can help me please. This is driving me crazy!

I have copied and adapted a script that displays a table with dates and times.

The script generates the dates 5 working days ahead and times from 7.00 till 16.00.

Every cell shows an "A".

When clicking a date, the script connects to the db and adds the date and time to the db.

I now need to show the dates and times that are in the db with a "B" for "booked".

The db has the following columns: id, deldate, deltime.

 

See script below:

 

<?php

$font_size = 1;

$how_many_business_days_ahead = 1;

$how_many_business_days_to_count = 10;

$numdel = 10; // number of deliveries per day

$deltimestart = 7; //start delivery time

$int = 1; // hourly interval between deliveries

 

$numdel = $numdel - 1;

$time = $deltimestart - $int;

 

/////////////////////////////

 

$server= "your_server";

$user= "user";

$password= "password";

$database= "database";

$table= "delivery";

 

MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server unreachable</H3>");

MYSQL_SELECT_DB($database) or die ( "<H3>Database non existent</H3>");

 

if ($date != "" && $time != "") { // This enters the data into the db

$req_date = $_REQUEST['date'];

$req_time = $_REQUEST['time'];

 

$insertion = "INSERT INTO $table VALUES ('','$req_date','$req_time')";

$result_insertion = mysql_query($insertion) or die ("Updating failed");

}

 

for ($c=0;$c<$how_many_business_days_to_count;$c++)

{

$jump=$c+$how_many_business_days_ahead;

$theday = strftime("%A", strtotime("+$jump"));

if($theday != "Saturday" and $theday != "Sunday")

{

$days = $how_many_business_days_ahead+$c;

$the_days[$j] = strftime("%Y-%m-%d", strtotime("+$jump days"));

$j++;

}

}

$k = $how_many_business_days_ahead;

 

echo "<table border=\"1\">";

echo "<tr><td></td>";

 

for ($a=0;$a<10;$a++){

$deltimefinish = $deltimestart;

$deltimestart = $deltimestart + $int;

echo "<td width=\"50\" align=\"center\"><font size=\"$font_size;\">$deltimefinish - $deltimestart</font></td>";

}

 

echo "</tr>";

 

foreach($the_days as $eachday){

echo "<tr><td><font size=\"$font_size\">";

echo strftime("%a, %d %b", strtotime("$eachday"));

echo "</font></td>";

$k++;

 

for ($i=0;$i<=$numdel;$i++){

 

if ($time>"15"){

$time = "7";

echo "<td align=\"center\"><font size=\"$font_size\"><a href=\"deliverydates.php?date=$eachday&time=$time\">A</a></font></td>";

} else {

$time = $time + 1;

echo "<td align=\"center\"><font size=\"$font_size\"><a href=\"deliverydates.php?date=$eachday&time=$time\">A</a></font></td>";

}

}

}

echo "</tr>";

echo "</table>";

 

/* Close SQL-connection */

MYSQL_CLOSE();

?>