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.

PDO is PHP Data Objects which is used to connect to any database. Benefit of using PDO is that if there is any problem in our query it has an exception class to handle it. If any exception thrown to ...

In this article, I’ll discuss some of the more frequently used methods for consolidating data from multiple tables into a single result set: SELECT, JOIN, UNION and subqueries.