Hola tengo los siguientes campos
tengo una tabla con los campos:
a06 hasta
a20 y cada uno de ellos contiene un valor 1 ó 0 (cero), quisiera hacer un conteo por cada registro y al final hacer una sumatoria, he hecho esto pero no sé si puede causar algun embotellamiento al motor mysql de mi localhost
Código PHP:
//Contar los campos en que los usuarios han hecho un clic
$a06= mysql_query("SELECT COUNT(*) FROM retornos WHERE a06 ='1'");
$count_a06 = mysql_result($a06,0);
$a07= mysql_query("SELECT COUNT(*) FROM retornos WHERE a07 ='1'");
$count_a07 = mysql_result($a07,0);
$a08= mysql_query("SELECT COUNT(*) FROM retornos WHERE a08 ='1'");
$count_a08 = mysql_result($a08,0);
$a09= mysql_query("SELECT COUNT(*) FROM retornos WHERE a09 ='1'");
$count_a09 = mysql_result($a09,0);
$a10= mysql_query("SELECT COUNT(*) FROM retornos WHERE a10 ='1'");
$count_a10 = mysql_result($a10,0);
$a11= mysql_query("SELECT COUNT(*) FROM retornos WHERE a11 ='1'");
$count_a11 = mysql_result($a11,0);
$a12= mysql_query("SELECT COUNT(*) FROM retornos WHERE a12 ='1'");
$count_a12 = mysql_result($a12,0);
$a13= mysql_query("SELECT COUNT(*) FROM retornos WHERE a13 ='1'");
$count_a13 = mysql_result($a13,0);
$a14= mysql_query("SELECT COUNT(*) FROM retornos WHERE a14 ='1'");
$count_a14 = mysql_result($a14,0);
$a15= mysql_query("SELECT COUNT(*) FROM retornos WHERE a15 ='1'");
$count_a15 = mysql_result($a15,0);
$a16= mysql_query("SELECT COUNT(*) FROM retornos WHERE a16 ='1'");
$count_a16 = mysql_result($a16,0);
$a17= mysql_query("SELECT COUNT(*) FROM retornos WHERE a17 ='1'");
$count_a17 = mysql_result($a17,0);
$a18= mysql_query("SELECT COUNT(*) FROM retornos WHERE a18 ='1'");
$count_a18 = mysql_result($a18,0);
$a19= mysql_query("SELECT COUNT(*) FROM retornos WHERE a19 ='1'");
$count_a19 = mysql_result($a19,0);
$a20= mysql_query("SELECT COUNT(*) FROM retornos WHERE a20 ='1'");
$count_a20 = mysql_result($a20,0);