[RESOLVED] Add Campaigns

Channel5

Hi all,

I'm trying to add campaigns to my autoresponder so that the order of the newsletters sent out can be organized into different groupings.

So far what I have is just one campaign with a table called newsletters that holds all the newsletters.

I'm thinking I'll have to create another table called campaigns that will have an array issuing the order or sequence by pulling the appropriate IDs from my newsletters table.

Any suggestions on this? I'm not too familiar with arrays in MySQL.

I'm guessing I would need two pieces of information for each value: 1 for the newsletter and the other for the position in the sequence.

Feedback much appreciated.

Channel5

Bump... anyone?

tron00

Kinda hard to tell what you are trying to do. Could use a little bit more info. Maybe create one table called campaigns and then another one for newsletters. This way, newsletters can be associated with campaigns.

Channel5

tron00;10907923 wrote:
Kinda hard to tell what you are trying to do. Could use a little bit more info. Maybe create one table called campaigns and then another one for newsletters. This way, newsletters can be associated with campaigns.

That's exactly what I'm trying to do.

But my problem is that I don't know how to add the newsletter to the campaign.

Say my newsletter table has 3 newsletters:

Newsletter 1
Newsletter 2
Newsletter 3

And I want to make 2 campaigns:

CAMPAIGN #1:

Newsletter 3
Newsletter 2
Newsletter 1

CAMPAIGN #1:

Newsletter 2
Newsletter 3
Newsletter 1

I was thinking I would use an array in the Campaign Table, with the order. So Campaign #1 would have 3,2,1 as the value and Campaign #2 would have 2,3,1 as the value.

Would this work?

If so, my first question would be: How do I get the values?

Would I have to unserialize() the value to figure out which newsletter to send everytime?

dagon

better to add a campaign table, with campaign_id | newsletter_id

Channel5

Damn!

Thanks!

I've been putting coding this one off for awhile, thinking it's going to be some complex problem, only to realize now that it's so simple.

Speaking for myself, perhaps sometimes being "smart" gets in the way of actually thinking "smart". 😉