[email?protected]>

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!

Subject
Body	wrap="PHYSICAL"> echo $strBody ?>
Category	Party

type="submit" value="Sende email">

}

if (isset($btnSendEmail))

{????echo "Send Email
";

// 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
";

// 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
";

}

}

?>

原文：http://www.jb51.net/article/1910.htm