Hey all,
My challenge is to get each <TD> to span multiple rows but I've declared the <TD> already after resource as $rft
Any work arounds?
<?php
foreach($resource as $rft)
{
echo "<td>";
$abc = $rft['id'];
$sqlb = "select * from bookings where resource = $abc";
foreach($sqlb2 as $rb2)
{
$str_time = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", date('H:i:s', strtotime($rb2['start'])));
sscanf($str_time, "%d:%d:%d", $hours, $minutes, $seconds);
$time_seconds3 = $hours * 3600 + $minutes * 60 + $seconds;
$str_time2 = preg_replace("/^([\d]{1,2})\:([\d]{2})$/", "00:$1:$2", date('H:i:s', strtotime($rb2['end'])));
sscanf($str_time2, "%d:%d:%d", $hours, $minutes, $seconds);
$time_seconds4 = $hours * 3600 + $minutes * 60 + $seconds;
$bkg = ($time_seconds4 - $time_seconds3) / 1800;
if($time_seconds3 == $t7)
{
echo "Booked: Thursday, 25 April 2024 - 13:05";
}
}
echo "</td>";
}