I have a table which shows my data and it works perfectly. I need to add in a pie chart also to show the exact same data that was shown on the table.

```
 <thead>
                <tr>
                    <th>Account Type</th>
                    <th>Account Number</th>
                    <th>Account Balance</th>
                </tr>
            </thead>
                <?php
                $query = "SELECT * FROM account WHERE user_id='$user_id'";
                $result = mysqli_query($link, $query) or die(mysqli_error($link));
                while ($row = mysqli_fetch_array($result)) {
                    $acc_type = $row ['account_type'];
                    $acc_num = $row ['account_number'];  
                    $acc_bal = $row ['account_balance']; 

                    ?>
                <tbody>
                    <tr>
                        <td><?php echo $acc_type ?></td>
                        <td><?php echo $acc_num ?></td>
                        <td>$ <?php echo $acc_bal ?></td>
                    <?php
                }
                ?> 
                    </tr>
            </tbody>  
            <tr class="alt">
                <?php 
                $query = "SELECT SUM(account_balance) AS account_total FROM account WHERE user_id='$user_id'";
                $result = mysqli_query($link, $query) or die(mysqli_error($link));
                while ($row = mysqli_fetch_array($result)){
                    $acc_total = $row ['account_total'];
                ?>
                <td colspan="2" align="right"><b>Total: </b></td>
                <td align="right"><b>$ <?php echo $acc_total ?> </b></td>
                <?php
                }
                ?>
            </tr>

```