Helpful Information

Category: MySQL and other databases

want to create a sql database driven newsletter

so long title I know, sorry about that.
I want to go ahead and create a database newsletter, which shouldn't be to hard. any thoughts though as to a particular script that it am going to want to use so I don't have to leave my browser open when sending my newsletter out to thousands. perhaps if it only had to be open for a few minutes or even seconds after I hit send that would be great.
thoughts or tutorials on any part of this idea.

thought this (http://www.php-mysql-tutorial.com/connect-to-mysql-using-php.php) might help :D

anyone have thoughts on if i want to allow my desiner to take his html and css and paste into a field, and than have that field be what is read and sent out? i can simply take the field in a php setting and of something like this.

// newsletter
if (isset($_POST['nl'])) {
$message .= "\nwhatGoesHere\n";
$message .= $_POST['nl'];
$message .= "\n";

}

and then chase it up with something like this

$headers = "From: {$_POST['myCompany']}\n";
$headers .= "Reply-to: {$_POST['mycompany@consumer.com']}\n";

mail("somesort of sql database", "subject", $message);

anythoughts? am i on the right page? just wondering on how i put that html into place of the newsletter and allow php to read it to send it out?
thankx guys.

Good news