Display database statistics without multiple recordsets
I created a page to show database statistics from a single table. Example total records from dues paid column containing 2014. As I knew no other way, I used $totalRows from a recordset to get this information. This worked well. The problem is I keep getting new ideas of statistics to list so now I have many, many recordsets in the page, which I have to believe is not a good idea.
How else can this be done? Also since I will probably recreate the page, can this be done with the MySQLi Server Behaviors