Group data in HTML table

[mannerheim]

Hello,

I have the following PHP code:

 

$query = mysql_query("SELECT
societati.denumire_soc,
incasari.Data_Facturii,
incasari.Nr_Factura,
incasari.ARTICOLNUME,
incasari.Valoare_factura,
incasari.suma_achitata,
incasari.modalitate_plata,
incasari.data_achitat
FROM
incasari
Inner Join users ON users.id_vip = incasari.inspectorid
Inner Join societati ON societati.id_vip = incasari.PartID
WHERE incasari.inspectorid = $vipid
ORDER BY societati.denumire_soc ASC, incasari.Data_Facturii ASC");


$htmloutput = '';



$htmloutput .= '<br/>


<div id="wrapper3" align="center">

<center><h2>Situatie autorizatii societati comerciale</h2></center>

<table width="100%" border="0" cellspacing="0 cellpadding="5">
    <tr>
       <td class="colhead">Denumire societate</td>
       <td class="colhead">Data Factura</td>
       <td class="colhead">Nr Factura</td>
       <td class="colhead">Articol</td>
       <td class="colhead">Valoare Factura</td>
       <td class="colhead">Suma Achitata</td>
       <td class="colhead">Modalitate Plata</td>
       <td class="colhead">Data Plata</td>
    
    </tr>';


$societate = '';


while ($row = mysql_fetch_array($query))
{
    
    
    
    $htmloutput .=  
   '<tr>
       
    <td class="societati">'.$row["denumire_soc"].'</td>
    <td class="societati">'.$row["Data_Facturii"].'</td>
    <td class="societati">'.$row["Nr_Factura"].'</td>
    <td class="societati">'.$row["ARTICOLNUME"].'</td>
    <td class="societati">'.$row["Valoare_factura"].'</td>
    <td class="societati">'.$row["suma_achitata"].'</td>
    <td class="societati">'.$row["modalitate_plata"].'</td>
    <td class="societati">'.$row["data_achitat"].'</td>

</tr>';
    
    
    
}



$htmloutput .='</table>
</div>';

 

this outputs:

 

SOCIETY1 2010-02-18 ADA140436 Dr aut ambiental (unitati alimentatie publica) an 2010 3094 3094 OP 2010-02-03

SOCIETY1 2010-02-18 ADA140436 Dr aut ambiental (turism) an 2010 3094 3094 OP 2010-02-03

 

As you can see the rows are duplicated by fourth field.

 

I want to display it like this:

 

SOCIETY1 2010-02-18 ADA140436 Dr aut ambiental (unitati alimentatie publica) an 2010 3094 3094 OP 2010-02-03

                                                                Dr aut ambiental (turism)