[MySql] Count multipla

[ANTAGONIA]

ho fatto in questo modo lato 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.