I am creating a newsletter website. Upon registration the user will be able to select theoretically a hundred newsletters to receive. My question is how do I store that data in the database? Each newsletter is unique and each user will have a different selection of choices. I won't want to make 100 different table columns for each newsletter will I? Any ideas?
member(id, etc, etc)
newsletters(newsID, etc, etc)
in other words a standard many to many relationship resolved into two one to many relationships. This is very basic Databases 101...