php - Mysql，删除具有多个值的行

Question

_{(来源:visedeg.no)}

在图片上您看到我有具有相同值的行。我只想给他们看一次。该行中的值是第 9 周每笔钱的总和。

<? 
$result5 = mysql_query("SELECT * FROM Donering WHERE Uke=".$Uke."");

while ($row1 = mysql_fetch_array($result5)){
    $nick = $row1['nickid'];
    $result6 = mysql_query("SELECT * FROM Donering WHERE nickid=".$nick." and Uke=".$Uke."  ");

    echo "<table border='1'>
        <tr>
        <th>Brukernavn</th>
        <th>Kr</th>
        <th>Uke</th>
        </tr>";

    while ($row = mysql_fetch_array($result6))  {
        $sum2 = $sum2+$row['Penger'];
        $DittNick = $row['Nick'];
    }

    if ($sum2 >= 2500000000) {
        $Fargekode = "#00FF00";
    }
    else {
        $Fargekode = "#FF0000";
    }

    echo "<tr>";
    echo "<td>" . $DittNick . "</td>";
    echo "<td><font color='".$Fargekode."'>". number_format ($sum2 , 0, ',', '.'  ) . "   </font></td>";
    echo "<td>Uke ".$Uke."</td>";
    echo "</tr>";

    echo "</table>";

    $sum2 = NULL;
}?>

Answer 1

首先，mysql_* 已被弃用。请参阅我的答案底部以获取更多信息。如果你不这样做，有一天你的代码将毫无用处。

对于您的实际查询，请尝试使用SELECT DISTINCT。这将拉出唯一的行。

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.