I'm trying to make a survey like a referundum to know if my neighboors in my small building are for or against a colectif compost to reduce the organics wastes.
For this tool vote I'm using PHP and SQL, my database is build like this:
column1=id PRIMARY AI
To build a chart with statistics vote results (% of YES, NO, BLANK..) I want to make a query on my database to count the number of YES NO AND BLANK but I don't know how. Can you help me please?
If you need more information about my code ask me everything.