Dynamic TD Rowspan

[mannerheim]

I have the following code snippet:

$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 societati ON societati.id_vip = incasari.PartID
WHERE incasari.inspectorid = $vipid

ORDER BY societati.denumire_soc ASC, incasari.Data_Facturii ASC, incasari.Nr_Factura ASC
") or die (mysql_error());




//$query2 = mysql_query("");


$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">Nr crt</td>
       <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>
       <td class="colhead">Count</td>

</tr>';


$nrfactura = NULL;
$tmpCount = 0;

while ($row = mysql_fetch_array($query))
{








if($nrfactura == $row["Nr_Factura"])
{
    $facturanumar = '';
    $utilizator = '';
    $datafacturii = '';

}elseif($nrfactura !=$row["Nr_Factura"])
{

$facturanumar = $row["Nr_Factura"];
$utilizator = $row["denumire_soc"];
$datafacturii = $row["Data_Facturii"];
  $tmpCount ++;
}




$htmloutput .=  
   '<tr>
    <td class="societati">'.$tmpCount.'</td>   

    <td class="societati">'.$utilizator.'</td>
    <td class="societati">'.$datafacturii.'</td>
    <td class="societati">'.$facturanumar.'</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>
    <td class="societati">'.count($row[""]).'</td>


</tr>';


 $nrfactura =$row["Nr_Factura"];    



}



$htmloutput .='</table>

Now what I want to do is to determine the number of "ARTICOLNUME" for each "Nr_Factura" to determine the value of rowspan for the rows that don't duplicate.

Thank you!

[leatherback]

You could naturally run the query twice. Once to get the number of rows per article. And once to get the data.

The other option would be to create an array variable for the individual cells, and count the number of rouws. THen when you get a new group, you create the output based on the arrays, while you know the number of rows retrieved.

[johanafm]

mannerheim wrote:

Now what i want to do is determine the number of incasari.ARTICOLNUME for each Nr_Factura, so that I can rowspan the other <td>'s with that value.

mannerheim in another post wrote:

Now what I want to do is to determine the number of "ARTICOLNUME" for each "Nr_Factura" to determine the value of rowspan for the rows that don't duplicate.

Another things you might consider doing, is NOT cross posting.