loop - php while break



Problèmes de positionnement correct des en-têtes de table (1)

J'ai des difficultés avec une table que j'essaie de créer.

J'ai un tableau d'utilisateurs qui affiche les utilisateurs dans ma table de base de données. Il y a 10 utilisateurs dans ceci. Ensuite, je devrais avoir 14 joueurs sous chaque utilisateur. Comme ça...

utilisateur1 utilisateur2 utilisateur3

joueur1 joueur1 joueur1

joueur2 joueur2 joueur2

joueur3 joueur3 joueur3

etc..

En ce moment, il le fait

Voici mon code ...

<table class="draft_border_table">
        <tr>
            <th>Rnd</th>
            <th><?php echo "<div>" . $draft_order_row['username'] . "</div>"; ?></th>
<?php               
while($draft_order_row = mysqli_fetch_array($draft_order_stmt)) {
?>  

            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player1 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player2 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player3 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player4 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player5 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player6 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player7 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player8 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player9 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player10 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player11 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player12 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player13 . "</div>"; ?></td>
                <td><?php echo "<div class='draftBorder'>" . $player14 . "</div>"; ?></td>
            </tr>
        </table>        
<?php
}
?>

Qu'est-ce que je fais mal?

METTRE À JOUR:

<table class="draft_border_table">
        <tr>
            <th>Rnd</th>

<?php 
while($draft_username_row = mysqli_fetch_array($draft_order_stmt2)) {
    $username = $draft_username_row['username'];
?>

                <th><?php echo "<div>" . $username . "</div>"; ?></th>
<?php
}
?>
            </tr>
<?php
$count = 1;
while($draft_order_row = mysqli_fetch_array($draft_order_stmt)) {
    $count + 1;
    $player1 = $draft_order_row['player1'];
    $player2 = $draft_order_row['player2'];
    $player3 = $draft_order_row['player3'];
    $player4 = $draft_order_row['player4'];
    $player5 = $draft_order_row['player5'];
    $player6 = $draft_order_row['player6'];
    $player7 = $draft_order_row['player7'];
    $player8 = $draft_order_row['player8'];
    $player9 = $draft_order_row['player9'];
    $player10 = $draft_order_row['player10'];
    $player11 = $draft_order_row['player11'];
    $player12 = $draft_order_row['player12'];
    $player13 = $draft_order_row['player13'];
    $player14 = $draft_order_row['player14'];
?>
<tr>
            </tr>
            <tr>
                <td><?php echo $count; ?></td>
            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player1 . "</div>"; ?></td>
            </tr>
            <tr>
                <td><?php echo "<div class='draftBorder'>" . $player2 . "</div>"; ?></td>
            </tr>


Essaye ça:

<table class="draft_border_table">
    <tr>
        <th>Rnd</th>
<?php

while ($draft_user_row = mysqli_fetch_array($draft_order_stmt2)) {

    $username = $draft_user_row['username'];

    echo "<th><div>" . $username . "</div></th>";

}
?>

    </tr>

<?php
for ($count = 1; $count < 15; $count++) {

    $col = "player" . $count;
    $query = "SELECT $col FROM user_players ORDER BY id";
    $draft_order_stmt = mysqli_query($con, $query);

    echo "<tr><td>" . $count . "</td>";

    while (list($players) = mysqli_fetch_array($draft_order_stmt)) {

        echo "<td><div class=\"draftBorder\">";

        if ($players == NULL) {

            $players = "&nbsp;";

        }

        echo $players . "</div></td>";

    }

    echo "</tr>";
}
?>
</table>




html-table