tallying information from database

[riffy]

Hi all,

I have a table in my database with about 64 columns. There are 27 questions, each with 4 radio buttons having the values 1,2,3,4. So 27 columns in the table have one of those values stored in them.
My question is whether there a way I can tally how many 1's there are, 2's there are, 3's there are and 4's there are in the table?

Can anyone help?

Thanks
Arif

😕 😕

[bastien]

function on mysql

http://www.mysql.com/doc/en/Group_by_functions.html

[riffy]

thanks bastien for your help

now i have another question...is there a way i can put that in a loop so that it adds how many 1's there are...

also what is wrong with this code, actually i know what is wrong but i don't know how to fix it

$c = 1;
for ($c;$c<28;$c++) {
for ($j=1;$j<=4;$j++) {
$sql= "select count(*) from survey where question.$c=$j";
$result = mysql_query ($sql2);
$result_row = mysql_fetch_row($result);
$field = $result_row[0];
print "$field<br>";
}
}

There are 27 columns with the numbers 1,2,3 or 4 in them and I want to list how many occurrences of each number are in each column.

Can anyone help?

Thanks