Data need to view in group

Simply i get data from query, but i need to view data on table in group basis. I need to group jointno in group i mean, need to find same data and show it one and rowspan=”count data”. this thing i already tried, and get good result.
But now i need to achieve group in lineno according to jointno, group of dia according to jointno. and same thing in lengths, thick and welder.

I try with bellow code.

<tbody>

    <?php
    include('../connect.php');
    $id = $_GET['id'];
    $resultx = $db->prepare("SELECT * FROM rt_data where report_id= :a");
    $resultx->bindParam(':a', $id);
    $resultx->execute();

    $jointNoCounts = array(); // Array to store counts for each jointno

    for ($i = 0; $rowx = $resultx->fetch(); $i++) {
        // Count occurrences of each jointno
        $jointNo = $rowx['jointno'];
        if (!isset($jointNoCounts[$jointNo])) {
            $jointNoCounts[$jointNo] = 1;
        } else {
            $jointNoCounts[$jointNo]++;
        }
    }

    $resultx->execute(); // Resetting the result set

    for ($i = 0; $rowx = $resultx->fetch(); $i++) {
    ?>

        <tr>
            <td style="text-align: center;"><?php echo $rowx['lineno']; ?></td>
            <td style="text-align: center;"><?php echo $rowx['dia']; ?></td>
            <?php
            $jointNo = $rowx['jointno'];
            if (isset($jointNoCounts[$jointNo])) {
                // Output jointno and rowspan based on count
                echo '<td style="text-align: center;" rowspan="' . $jointNoCounts[$jointNo] . '">' . $jointNo . '</td>';
                unset($jointNoCounts[$jointNo]); // Remove the count for this jointno
            }
            ?>
            <td style="text-align: center;"><?php echo $rowx['lengths']; ?></td>
            <td style="text-align: center;"><?php echo $rowx['thick']; ?></td>
            <td style="text-align: center;"><?php echo $rowx['welder']; ?></td>
            <td style="text-align: center;"><?php echo $rowx['weldref']; ?></td>

            <td style="text-align: center;"><?php echo ($rowx['slag'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['porosity'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['undercut'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['conactivity'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['express'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['lopen'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['worm'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['tung'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['crack'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['lof'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['burn'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['accuim'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['aligind'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>
            <td style="text-align: center;"><?php echo ($rowx['discon'] == 1) ? '<i class="fa fa-check"></i>' : ''; ?></td>

            <td style="text-align: center;"><?php echo $rowx['accrej']; ?></td>
            <td><?php echo $rowx['remarks']; ?></td>
        </tr>
    <?php } ?>
</tbody>

Output Screenshot