I want to do some calculations based on a users input of yes/no answers. For example, what percentage of yes answers for the month of September, or the year 2006. What's the best way to do this in a mysql database with php pages? Should i store the information as "1" and "0" instead of "yes" and "no"? Will that make calculations easier on the database/php scripts? Please point me in the right direction, thanks!
I found this to count them, just don't know where to go from here:
select count(*) from tablename where answer = " Yes";
select count(*) from tablename where answer = " No";