我试图通过while循环从我的数据库输出信息.我希望结果显示如下……

姓氏姓氏 – 名字姓氏 – 名字姓氏

player1 ————— player1 ———————– player1

player2 —————- player2 ————————- player2

player3 —————— player3 ———————- player3

但是我的结果显示如下……

名字姓氏

player1 – player2 – player3

名字姓氏

player1 – player2 – player3

等等

Firstname,lastname,player1,player2和player 3都是我的db表中的所有列.每当有新用户时,他们就会插入新玩家的新行.

码：

<h1>Draft Order</h1>
<?PHP
$con = MysqLi_connect("localhost","","");
$stmt = MysqLi_query($con,"SELECT * From user_players");

while($row = MysqLi_fetch_array($stmt)) {
    $player1 = $row['player1'];
    $player2 = $row['player2'];
    $player3 = $row['player3'];
?>
        <div class="inline">
        <?PHP echo $row['firstname'] . " " . $row['lastname']; ?>
        </div>
        <div class="draftBorder">
<?PHP
echo $player1;
echo $player2;
echo $player3;
?>
        </div>
<?PHP
}
?>

CSS

.inline {
    display: inline;
    padding: 10px;
}
/*------Draft Page---*/
.draftBorder {
    border: 1px solid black;
    display: block;
}

我在名为’inline’的类中有firstname和lastname字段,以使这些字段内联,但它们显示为块.

我有一个名为’draftBorder’的类中的玩家并将其设置为阻止,但它显示为内联.

为什么这些显示相反,如何更改它以获得我想要的结果.

更新：现在显示…

名字 – 姓氏

PLAYER1

player2

player3

名字姓氏

PLAYER1

player2

player3

名字姓氏

PLAYER1

player2

player3

更新：从浮动：左;建议

firstname lastname —— player1

player3 —————— player2

firstname lastname —— player1

player3 —————— player2

firstname lastname —— player1

player3 —————— player2

<?PHP
    $con = MysqLi_connect("localhost","");
    $stmt = MysqLi_query($con,"SELECT CONCAT_WS(" ",first_name,last_name) AS fullname,player2,player3 From user_players");

    while($row = MysqLi_fetch_array($stmt)) {

    echo '<h1>Draft Order</h1>';

    echo '<div style="display: block; width: 100%;">';
    for($i=1; $i<4; ++$i){


       echo '<div class="draftBorder">';
       echo $row['fullname'];
       echo '</div>';

       echo '<div class="draftBorder">';
       echo $row['fullname'];
       echo '</div>';

       echo '<div class="draftBorder">';
       echo $row['fullname'];
       echo '</div>';


    }

 echo '</div>';



    echo '<div style="display: block; width: 100%;">';
    for($i=1; $i<4; ++$i){
    $player = $row['player'.$i]

       echo '<div class="draftBorder">';
       echo $player;
       echo '</div>';

       echo '<div class="draftBorder">';
       echo $player;
       echo '</div>';

       echo '<div class="draftBorder">';
       echo $player;
       echo '</div>';


    }

 echo '</div>';

 }
?>

.draftBorder {
    border: 1px solid black;
    display: inline-block;
    width: 33.33%;
}