display number of occurrences of an item in a list
Hi,
I have a database that contains dogs name, year achieve AKC Champion, and kennel name.
I would like to enhance the search (or create a new search similar to) found here http://www.oldenglishsheepdogclubofamerica.org/champions_titled.php so when a year was imputed, the search results would display a column indicating the number of occurrences of a particular kennel name and sort by that column. So the end result would produce a list as can be seen in the first column found here (this is a static page created manually) http://www.oldenglishsheepdogclubofamerica.org/statistics/kennels_producing_champions.php.
The main part I am having trouble with is the calculating/displaying the number of occurrences of each kennel name.
Thanks,
Dennis