如下：
Create this table The field "what" is for different categories CREATE TABLE email_notify ( ID int(11) DEFAULT '0' NOT NULL, What varchar(60) DEFAULT '0' NOT NULL, Name varchar(60) DEFAULT '0' NOT NULL, Email varchar(60) DEFAULT '0' NOT NULL, timestamp varchar(16), KEY (What), PRIMARY KEY (ID)); To fill this table you might create an insert form *******************************************************************************/ // Set this values: $strHost ="localhost"; $strUser ="root"; $strPassw =""; $strSender="[email protected]"; if (!$btnSendEmail) { ?> The email will be added automatically with "Hello Name" in the first line of the emailbody! `````` ```
``` `````` ```
}
if (isset($btnSendEmail))
{ echo "Send Email
1<br/>
";
// Create connection
$intConID = mysql_pconnect($strHost,$strUser,$strPassw);
// Header
$strHeader = "Return-Path: $strSender\nErrors-To: $strSender\nFrom:
$strSender";
// SQL
$strSQL = "select name,email from email_notify where lcase(what) =
'$strWhat'";
$intRes = mysql_query($strSQL,$intConID);
echo "Send Email $strBody
1<br/>
";
// fetch array
while($saRow = mysql_fetch_array($intRes))
{ $strEmail = $saRow["email"];
$strName = $saRow["name"];
$strBodyComplete = "Hello " . $strName[$i] . "!\n\n" . $strBody;
// Email
mail($strEmail,$strSubject,$strBodyComplete,$strHeader);
// Output
echo "Send to $strName
1<br/>
";
}
}