I would like to use php and mysql to achieve the following:
Potential subscribers provide their email address (and name and other information). When the form is submitted, I would like to have it perform these steps:
1. Updates a database with the submitted information.
2. Sends an email to the subscriber with a link to confirm the subscription.
3. Sends an email to me, the webmaster about their submitted details.
4. Presents a "thank you" page to the prospective subscriber.
Anyone willing to provide php script to achieve above. Any help will be appreciated.