ho fatto in questo modo lato php:
Codice PHP:
$arrCampiA = array('A01','A02','A03','A04','A05','A06','A07','A08','A09');//nomi dei campi per la TB_1
foreach ($arrCampiA as $key => $value) { $q = "quant_".$key;
$sqlMax = "SELECT ".$value.", COUNT(*) AS ".$q." FROM ".$DB.".TB_1 GROUP BY ".$value."";
$rs= mysql_query($sqlMax) or die ("Impossibile connettersi !" . mysql_error());
if (mysql_num_rows($rs) > 0) {
$i = 0;
while($arr[$i] = mysql_fetch_assoc($rs)) {
$i++;
}
unset($arr[$i]);
echo "<thead style='background-color:#000;color:#FFF'>
<tr>
<th data-priority='1'>".$value."</th>
<th data priority='2'>Totale</th>
</tr>
</thead>
<tbody>";
for ($i=0; $i<count($arr); $i++) {
echo "<tr>";
echo " <td>".$arr[$i][$value]. "</td>";
echo " <td>".$arr[$i][$q]. "=risposte per la domanda (".$arr[$i][$value].")</td>";
echo "</tr>";
echo "</tbody>";
}
}}
Cosi sembra funzionare.