I was hoping someone could help me out with this problem.
I have two tables with a many-to-many relation in the following format...
NEWSLETTERS (NewsletterID, Title):
SUBSCRIPTIONS (MemberID, NewsletterID):
So basically the SUBSCRIPTIONS table stores the "who is subscribed to what" data.
Now, for a given member I would like to return ALL newsletters togther with a TRUE/FALSE variable depending on whether that member has subscribed to each one.
For example, if I was Member3 the following rows would be returned if the data above applied...
I've tried all sorts of SELECT queries with joins - but none seem to product this result. Am I missing something here?!
BTW, I am using MySQL and PHP.
Thanks a lot,