[eluser]TheFuzzy0ne[/eluser]
Hi, guys.
I have a question and I'm hoping you might be able to help me.
I'm doing a free project for a friends' organisation, and he wanted the ability to post regional newsletters.
I have a database table for newsletters, which joins onto the members table and regions table. However, he's now asked if we can also allow posting of national newsletters. I'm not quite sure how to proceed, since I only took regional newsletters into account.
I was thinking of simply setting the region ID to 0 for national newsletters, but I'm unsure. I don't know if I should handle this with the regional newsletters, or if I should have a separate table and controller for national newsletters. Setting the region ID to 0 is a quick fix, but in the unlikely event he decides to add another kind of newsletter, it's going to cause problems.
I would really appreciate anyone's thoughts on the matter. I understand there are several ways to go about this, but I'm sure there's a way I haven't thought of that's probably better than any of the methods I have already thought of.
Many thanks in advance.