[RESOLVED] Counting values

[denzlite]

Newb quest - If I have a column in a mysql table that is filled with either yes or no values - how do I get the total of yes's / total of no's?

Not the sum of the values themselves, but the sum of rows?

THanks...

[NogDog]

SELECT col_name, COUNT(*) FROM table_name GROUP BY col_name

[denzlite]

thanks. then what php function would i use to display the query results?

[NogDog]

You'd use the same functions as for any other query, depending on which database extension you are using (MySQL or MySQLi). See the [man]mysql_fetch_array/man page for a typical example.