to php/mysql gurus
Reaching out to the php guys/gals on the list. I am using PowerMessenger database. My client wants a page that lists the members of each mailinggroup (committees).
So, setting up (in DW) a repeat region, tying record sets. I'm close but not there yet.
So, in PM, there are 3 tables:
pm1_users that uses UserID
pm1_groupsubscriptions that uses UserID and GroupID
pm1_mailingroups that uses GroupID
So I want to show all the users in a a particular mailinggroup.
SELECT *
FROM pm1_groupsubscriptions, pm1_users
WHERE GroupID = 10
(10 = one of the mailinggroups)
That isn't enough to get there. That shows everyone.
Brain freeze.
Any help, most appreciated.