retreiving values from single column

[techmeister]

Hi there:

I have a slightly confusing php/MySQL prob:
I have a table with a row named 'level' which contains seven possible values at any time: 'yes', 'no', 'strong_agree', 'agree', 'indifferent', 'disagree', 'strong_disagree'.

I want to be able to extract the number of yes/no/agree etc values from this column using a php embedded SQL statement, but have been fiddling with no success for a few hours now!

I am using php4.0.3 with MySQL 3.22.32

Many thanks for any help!
Russ

[[deleted]]

Use the group-by functions (check the mysql manual)

SELECT count(*),level FROM table GROUP BY level;