php - 数值统计表 PHP MYSQL

Question

我现在有一个统计表。

但我想要的是:

1.|Team
2.|Team
3.|Team

在团队之前我没有数字。我的 table 是由“Punten”订购的，因此无法与团队一起添加。在 td 之前它需要是静态的

这是我的代码:

    <?php
        $table = "e2teams";
        $sql = "SELECT ID, Team, Punten, Gespeeld, Gewonnen, Verloren, Gelijk, DPV, DPT, DPV-DPT AS Verschil FROM e2teams ORDER BY Punten DESC, Verschil DESC, DPV DESC";
        $result = mysql_query($sql, $dbhandle);


        echo "<table class='opmaaktable'><tr><td class='styled-td'>Team</td><td class='styled-td2'>G</td><td class='styled-td2'>W</td><td class='styled-td2'>GL</td><td class='styled-td2'>V</td><td class='styled-td2'>P</td><td class='styled-td2'>DPV</td><td class='styled-td2'>DPT</td><td class='styled-td2'>Vers.</td></tr></table>";  


        if(mysql_num_rows($result) > 0){
            $team = array();
            while($row = mysql_fetch_array($result)) {

                echo "<table><tr><td class='styled-td'>";
                echo $row['Team']. '</td><td class="styled-td2">';
                echo $row['Gespeeld']. '</td><td class="styled-td2">';
                echo $row['Gewonnen']. '</td><td class="styled-td2">';
                echo $row['Gelijk']. '</td><td class="styled-td2">';
                echo $row['Verloren']. '</td><td class="styled-td2">';
                echo $row['Punten']. '</td><td class="styled-td2">';
                echo $row['DPV']. '</td><td class="styled-td2">';
                echo $row['DPT']. '</td><td class="styled-td2">';
                echo $row['Verschil']. '</td><td class="styled-td2">';
                echo "</td></tr></table>";
                $team = $row['Team'];
                }
        }

    ?>

这就是它的样子:

希望你能帮上忙!

Answer 1

我不确定我是否遗漏了什么 - 但为什么不声明一个计数器并在循环中递增它呢？

$ctr = 1;
while($row = mysql_fetch_array($result)) {

    echo "<table><tr><td class='styled-td'>";
    echo "$ctr." . $row['Team']. '</td><td class="styled-td2">';
    ...
    $ctr++;
}