/******************************************************************************  
Description: This is a simple script to send emails via a html-form   
               to different users  
Date        : 1999-02-25  
Author        : amalesh kempf <amalesh@goatrance.de>  

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="you@domain.com";  

if (!$btnSendEmail)  
{  
?>  

The email will be added automatically with "Hello Name" in the first line of   
the emailbody!<br>  
<br>  

    <form action="send_email.php3" enctype="application/x-www-form-  
urlencoded" method="post">  
    <table>  
        <tr>  
            <td>Subject</td>  
            <td><input name="strSubject" size="40"></td>  
        </tr>  
        <tr>  
            <td>Body</td>  
            <td><textarea cols="40" name="strBody" rows="8"   
wrap="PHYSICAL"><? echo $strBody ?></textarea></td>  
        </tr>  
        <tr>  
            <td>Category</td>  
            <td>  
                <select name="strWhat">  
                <?php // add you categories here: ?>  
                <option value="party">Party</option>  
                </select>  
            </td>  
        </tr>  
    </table>  
    <input name="btnSendEmail" style="HEIGHT: 24px; WIDTH: 224px"   
type="submit" value="Sende email">  
    </form>  

<?php  
}  

if (isset($btnSendEmail))  
{    echo "Send Email<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<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<br>";  
    }  
}  
?>