select mysql by months

select, mysql, subscription

[silence]

Hi everybody.

I have an application that send emails to subscribers every week, every 14 days and every month, I select this information using an sql script. But now i need to implement the two months subscription.
I like to make an sql select that retrieves all the suscriptions by day so i can send the email to the people that subscribe for this newsletter.
Thanks for all your help.

Byron H.

[penders]

How do you currently implement the other subscriptions?

[silence]

Hi.
Actually, I'm doing every day a select in the database.
For example, for the weekly list, i do:
SELECT u.* FROM users_list u WHERE NOT ((DATEDIFF(CURDATE() , u.date_init)) % 7) and u.date_init < CURDATE();
But all the tests with the two months doesn't works.
Thanks for help.
Byron H.