473,215 Members | 1,306 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,215 software developers and data experts.

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


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

Nov 7 '06 #1
1 1320
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Manuel Hegemann | last post by:
Hello, i want for a newsletter to send html valid newsletters. per adminscript i save the context which will be sent to a mysql-database and get this data for the mail later on. it's a pitty, but...
by: Jeffrey Silverman | last post by:
Hi, all. Sorry, first off, for the kidna weird selection of crossposted groups, but this question touches on aspects of discussion in each of the groups. So I have a group of around 500 email...
by: cooldv | last post by:
i have an *access database + ASP newsletter* that is working fine and it sends newsletter to ALL the email addresses in the DB. i want to send this newsletter to only a select group (like people...
by: VB Programmer | last post by:
I have an HTML newsletter that I want to email to a bunch of people found in a database. 1. I want some parts of the newsletter to filled in dynamically from a database (company, address,...
by: Lampa Dario | last post by:
I'd like to create a little script to allow users to remove from mailing list. I use the folowing code $remove_msg='Lei riceve questo messaggio poiché si è iscritto alla newsletter. Potrà...
by: philb | last post by:
I'm busy googling for a php newsletter script, does anyone have any recommendations. I'm pretty new to php/mysql so I'm just looking for something nice and basic. Phil
by: fortwilliam | last post by:
I have a newsletter system and want to have it work automatically. what I have so far works with a visitor to a page with a tiny iframe in it. This iframe calls up the send.pl newsletter script....
by: Neil Gould | last post by:
Hi all, Thanks for the suggestions for our club's initial bulkmail sending routines. I did read up on the use of ASP vs. a separate COM app such as ASPEmail, and determined that for our club's...
by: rahulephp | last post by:
Hi there, I tried a lot to send HTML code using php mail fuction, but when email sent, it showing all html tags (including style property as well). Can you please let me know any script to send...
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.