i have two tables one item table and customer table:
[![enter image description here](https://i.stack.imgur.com/hc4nA.jpg)](https://i.stack.imgur.com/hc4nA.jpg)

in the table you can see the second item item id 1002 have two entries.and i want to add colspan to that item for column 1 and 3.

[![enter image description here](https://i.stack.imgur.com/h7F6U.jpg)](https://i.stack.imgur.com/h7F6U.jpg)

```
 <table>
  <tr>
    <th>Item ID</th>
    <th>Item Color</th>
    <th>Customer</th>
  </tr>
<?php
$sql = mysqi_query($con,"select * from item_table");
while($row = mysqli_fetch_array($sql)){
  ?>

<tr>
    <td><?=$row['item_id'];?></td>
    <td><?=$row['item_color'];?></td>
    <td>
        <select>
        <?php
        $sql_cust = mysqli_query($con,"select * from customer_tbl");
        while($row_cust = mysqli_fetch_array()){
        if($row['customer_id'] == $row_cust['customer_id']){
            echo "<option selected='selected' >".$row['customer_name']."</option>";
        }else{
            echo "<option>".$row['customer_name']."</option>";
        }

        <?php
        }
        ?>
        </select>
    </td>
  </tr>

<?php
}
?>
</table>

```

But it print in normal way, i have no idea how to add rowspan in loop..please suggest some logic to solve its appreciated.

[![enter image description here](https://i.stack.imgur.com/8DeNv.jpg)](https://i.stack.imgur.com/8DeNv.jpg)