Jason,
I want to display the total of all the counts (champions) displayed on the page by the recordset you helped me with. So if the search displays...
Kennel A 5 champions
Kennel B 4 champions
Total 9
To show the TOTAL you suggest the code (recordset) SELECT COUNT(idColumn) as recordCount FROM tableName
which makes sense, but I don't have an idColumn instead the recordset you suggested (reply #4 above) to create the list of champions uses an alias (I believe). Using that alias in place of idColumn gives an MySQL error.
The page can be seen here (I don't know how to make it a link with the new forum) - http://www.oldenglishsheepdogclubofamerica.org/top_kennels_WA.php
Dennis