code

$stmt = $mysqli->prepare("SELECT *****,*****,*****,**** FROM ***** WHERE user_id = $user_id")
        $stmt->bind_param('s', $user_id);
        $stmt->execute();    // Execute the prepared query.

        // get variables from result.
        $stmt->bind_result($accountno ,$accountname, $brokername, $revenue,$status);
        $stmt->fetch();

               echo "<table border='1'>
                <tr>
                <th>Account No</th>
                <th>Account Name</th>
                <th>Broker Name</th>
                <th>Revenue</th>
                </tr>";

                while($row = mysqli_fetch_array($stmt))
                {
                echo "<tr>";
                echo "<td>" . $row['*****'] . "</td>";
                echo "<td>" . $row['*****'] . "</td>";
                echo "<td>" . $row['*****'] . "</td>";
                echo "<td>" . $row['*****'] . "</td>";
                echo "</tr>";
                }
                echo "</table>";