php - todas - Problemas al hacer que los encabezados de las tablas se posicionen correctamente

repetir pie de pagina excel

Question

Estoy teniendo dificultades con una tabla que intento crear.

Tengo una matriz de usuarios que muestra los usuarios en mi tabla de base de datos. Hay 10 usuarios en esto. Entonces debería tener 14 jugadores debajo de cada usuario. Me gusta esto...

usuario1 usuario2 usuario3

jugador1 jugador1 jugador1

jugador2 jugador2 jugador2

jugador3 jugador3 jugador3

etc.

En este momento está haciendo esto

Aquí está mi código ...

<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é estoy haciendo mal?

ACTUALIZAR:

<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>

Answer 1

Prueba esto:

<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>