Forum Moderators: open
Table 1, called tbl_maillist_lists, stores the mailing list information (ID, Listname, Desc, Status[Active,Deleted].
Table 2, called tbl_maillist_users, stores the users who may or may not be subscribed to any of the lists (ID, Name, Email, ListID[the ID of the List they are subscribed to], Status[Active,Pending,Deleted,A-Inactive].
What I want to do, if you haven't already guessed, is output the TOTAL number of subscribers for each list, whereas they are ACTIVE users.
Example:
-------------------------------------
¦ Listname ¦ Desc ¦ Subscribers ¦
-------------------------------------
¦ ListA ¦ Fun List ¦ 76 ¦
-------------------------------------