У меня возникают трудности с таблицей, которую я пытаюсь создать.
У меня есть массив пользователей, который отображает пользователей в моей таблице базы данных. В этом есть 10 пользователей. Тогда у меня должно быть 14 игроков под каждым пользователем. Как это…
user1 user2 user3
игрок1 игрок1 игрок1
игрок2 плеер2 плеер2
игрок3 плеер3 плеер3
и т.д..
Сейчас он делает это
Вот мой код …
<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 } ?>
Что я делаю не так?
ОБНОВИТЬ:
<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>
Попробуй это:
<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 = " "; } echo $players . "</div></td>"; } echo "</tr>"; } ?> </table>