My table has following structure (along with few other columns)
product a1 a2 a3 a4
abc yes no yes no
pqr yes yes no yes
xyz yes yes yes yes
I need to run a query which will return the total count of yes:
How can i return the same using PHP mySQL.