Record count of dates selection

Hi all

I am creating a meeting booking application and have a MySql table of available meeting dates.

These dates are placed in a form on a Cfm page for the responders to select the meeting they would like to attend. The results are in a second table of results. All of this is pretty straight forward stuff. Folk can then see who wants to attend each of the available meetings.

I have now been asked to give a summary of how many responders have selected each of the available dates.

I think that I am overcomplicating things so any advice on a simple way to go about this would be appreciated.

Can a MySql command do a record count of each date in the results table or will I have to loop through the meeting dates table to get each date from the results table and then do a select for each date and a record count of that.


I hope that makes sense. Any advice would be welcomed.

Thanks,

Paul.