How to display the total number of same text entries from a table (php)?

Report · Apr 30, 2012

Hello,

I have a database "choir" with the table "members" which has the following data structure:

With Dreamweaver php, any help me on how can I display in a webpage the total number of "alto", in this case: 4.

Thanks,

Luci.

Report · Apr 30, 2012

Create a new Recordset in Dreamweaver and run the following SQL:

SELECT voice, count(voice) AS voiceCount FROM choir GROUP BY voice

Report · Apr 30, 2012

Hi,

Thanks for your fast reply. I've used your proposal and it works fine.

However, I get only the value 4.

What I would like is:

alto 4

bass 1

soprano 2

tenor 2

Any help on how can I achieve this?

Thank you very much?

Report · Apr 30, 2012

SELECT voice, COUNT(*) as voice FROM choir GROUP BY voice ORDER BY voice DESC;

This will give you plain voiceid - count

SELECT voice, COUNT(*) as name FROM choir GROUP BY voice ORDER BY voice DESC;

This will give you name - voice - count

Trust it helps.

Cheers,

ST

Report · Apr 30, 2012

Thank you very much. This is what I wanted.

I have also another harder request. I've put it separately.

If you could help me on that too, I would be higly appreciating.

Thanks!

1 Correct answer