
<table id="dt-basic-example" class="table table-hover w-100" style="font-size: 11px;">
    <thead class="header bg-primary" style="color: #fff;">
        <tr>
            <th style="font-weight: bold;width: 5px;"></th>            
            <th style="font-weight: bold;">Supp/Subco Category</th>
            <th style="font-weight: bold;">Type</th>
            <th class="text-right" style="font-weight: bold;">Action</th>
        </tr>
    </thead>

    <tbody>
    <?php
        $i = 0;
        $sql = $conn->prepare("SELECT * FROM tbl_categ_su c
        INNER JOIN tbl_s_s s ON s.ss_id=c.ss_type
         ORDER BY c.ctg_name ASC");
        $sql->execute();
        while($fetch = $sql->fetch()){
        $i++;
    ?>
        <tr>
            <td><?php echo $i; ?></td>
            <td><?php echo $fetch['ctg_name']; ?></td>
            <td><?php echo $fetch['namesu']; ?></td>
            <td class="cell-icon text-right">
                <a href="gate?b=ssctg&s=<?php echo $fetch['ctg_id'];?>" class="edit_data"><i class="fa fa-edit"></i> Edit</a>|
                <a href="#" data-toggle="modal" data-target="#del<?php echo $fetch['ctg_id'];?>" style="color: #ab3f3b"><i class="fa fa-trash-o"></i> Delete</span></a>
            </td>
        </tr>
    <?php
        include 'delsuctg.php';
        }
    ?>
    </tbody>                           
</table>