468,268 Members | 1,743 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,268 developers. It's quick & easy.

Need a script to send an online course in 20 lessons / newsletter

Hey,

i am searching for a php script that features sending a lets say 20
lesson online course.
it should:

subscription on website
opt-in after subsriciption
send one lesson per day to every subscriber
first lesson on the day of subscription
easy unsusubscribe on website
comfortable managing the list / statstic

I searched for scripts and only found newsletter-scripts
where every user get the same (and not "his" lesson !!!)
every day or whatever.

Any ideas?
Thank you for your help
Sebastian

Nov 7 '06 #1
1 1164
Assuming you have a database....

build a table for subsribers holding their personal information,
including registration date.

build a table for courses course details

build a table for lessons with a key of courseID/lesson#

Build a cross reference table between subscribers and their courses

you then need a script that does the following:-

find first subsriber - gives you the email address:
find first cross reference record for the subscriber - gives you
the course ID
work out number of days since subsription - gives you the
lesson ID.
fire off an email to the email address for the lesson
find next cross reference record for the subsriber and repeat
indented section
find next subsriber and repeat indented section

This is pretty simple simple using While or For-Next loops but really
depends on your database structure.

Nov 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Manuel Hegemann | last post: by
6 posts views Thread by Jeffrey Silverman | last post: by
4 posts views Thread by VB Programmer | last post: by
1 post views Thread by Lampa Dario | last post: by
2 posts views Thread by philb | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.