Mysql, remove row with multiple values

Question

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;
}?>

Use Group By with your query

Deadlock
– Deadlock

2013-02-28 13:36:28 +00:00
Commented Feb 28, 2013 at 13:36 — Deadlock
– Deadlock, Commented Feb 28, 2013 at 13:36
Of course :) how could i be so stupid. Tnx !

Emil Søreng
– Emil Søreng

2013-02-28 21:12:00 +00:00
Commented Feb 28, 2013 at 21:12 — Emil Søreng
– Emil Søreng, Commented Feb 28, 2013 at 21:12

Zoe - Save the data dump · Accepted Answer · 2019-05-25 14:28:33Z

2

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.

edited May 25, 2019 at 14:28

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Feb 28, 2013 at 13:36

burmat

2,5481 gold badge23 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alejandro · Accepted Answer · 2013-02-28 13:35:58Z

0

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

answered Feb 28, 2013 at 13:35

Alejandro

5822 gold badges7 silver badges35 bronze badges

5 Comments

Emil Søreng Over a year ago

Tnx for fast replay. But then this happend: visedeg.no/images/lewl5e0yk5ciw89jfif1.png

Alejandro Over a year ago

I misunderstand the question, but maybe this will help too (thats why I didnt deleted it)

Alejandro Over a year ago

Did you move the </table> out of the while?

Emil Søreng Over a year ago

That was the html? Do you mean CSS?

Alejandro Over a year ago

The html result of the php. Right click->show source in the browser

Razorphyn · Accepted Answer · 2013-02-28 13:39:00Z

0

You can try to use DISTINCT option in your MySQL string

answered Feb 28, 2013 at 13:39

Razorphyn

1,33215 silver badges38 bronze badges

Collectives™ on Stack Overflow

Mysql, remove row with multiple values

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related