php - 带有子表的表数组数据

Question

关于使用 Php 和 Mysql 的带有表的数组元素，我对此有疑问，所以目标是标题按日期显示子表。理论上显示两个表数组。你能帮助我吗？

图片样本：

我用 Mysql 粘贴代码 PHP。

echo "<table class='tbmapa' width='300px' align='center'>";
echo "<col width='30%'><col width='60%'>";
$query = "SELECT fecdate FROM incidents";
$result = $conn->query($query);
while($row = $result->fetch_assoc()){
    echo "<thead><tr>";
    echo "<th>DAY N° 01</th>";
    echo "<th id='data'>".$row['fecdate']."</th>";
    echo "</thead></tr>";
    echo "</table>";
    $i=0;
    $conn->next_result();
    $query2 = "SELECT secc, time, desc, obs FROM incidents WHERE fecdate = '$_GET['data']'";
    echo "<table class='tbmapa' width='300px' align='center'>";
    echo "<col width='10%'><col width='10%'><col width='40%'><col width='30%'><col width='5%'><col width='5%'>";
    echo "<thead>";
    echo "<tr>";
    echo "<th>SEC</th>";
    echo "<th>TIME</th>";
    echo "<th>DESCRIPTION</th>";
    echo "<th>OBS</th>";
    echo "<th>EDIT</th>";
    echo "<th>SEND</th>";
    echo "</tr>";
    echo "</thead>";
    echo "<tbody>";
    $result1 = $conn->query($query2);
    while($rowdb = $result1->fetch_assoc()){
        echo "<tr>";
        echo "<td>".$rowdb['secc']."</td>";
        echo "<td>".$rowdb['time']."</td>";
        echo "<td>".$rowdb['desc']."</td>";
        echo "<td>".$rowdb['obs']."</td>";
        echo "<td>EDIT</td>";
        echo "<td>SEND</td>";
        echo "</tr>";
        $i++;
    }
    echo "</tbody>";
    echo "</table>";
    $x++;
}
$result->close();

感谢

标签： phphtmlarraysmysqlihtml-table