Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query. You must ensure that the table exists before running a query on the table.

When I put this in phpMyAdmin, I get the exact results I want in a pretty table with two columns, the tkid and the count for how many times that tkid shows up in the xd2e_trooptrack_attendee table ...