CODEWITHSUNDEEP
phpmysql
Emil Søreng
Emil Søreng

Reputation: 1

Mysql, remove row with multiple values

image
(source: visedeg.no)

On the picture you see i have rows with same value. I want to show them only one time. The values in the row is a sum of every money in week 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;
}?>

Upvotes: 0

Views: 129

Answers (3)

burmat
burmat

Reputation: 2548

First of all, mysql_* is being deprecated. Look at the bottom of my answer for more information on that. If you don't, some day your code will be useless.

For you actual query, try using SELECT DISTINCT. This will pull unique rows.

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.

Upvotes: 2

Razorphyn
Razorphyn

Reputation: 1332

You can try to use DISTINCT option in your MySQL string

Upvotes: 0

Alejandro
Alejandro

Reputation: 573

Maybe you are looking for this, move the header of the table, and the close out of the while

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

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

while ($row1 = mysql_fetch_array($result5)){
$nick = $row1['nickid'];

$result6 = mysql_query("SELECT * FROM Donering WHERE nickid=".$nick." and Uke=".$Uke."  ");



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



  $sum2 = NULL;

  }

  echo "</table>";?>

Upvotes: 0

Related Questions