[Resolved] send birthday email

[sirTemplar]

hi. this is my sql query to print people whose celebrating their birthday on current day:

$result = mysql_query	("SELECT NAME, SURNAME, EMAIL,
            YEAR(NATDAT) AS NATYEAR FROM table
           WHERE substring(NATDAT,6) = substring(curdate(),6)
           ORDER BY SURNAME ASC, NOMRL
						",$conn);

if ($row = mysql_fetch_array($result)) {
do {
                        echo  "etc. etc.......................

it works fine. what i want to do now is to create a script that when i run it will automaticall send an email to people celebrating their bday on current day.

i tried adding this after the querry but it doesn't work:

<?

//Send email to user

$headers = "Content-Type: text/html";
$headers = "From: My Website <[e-mail]>"; 
$email = $row ['EMAIL']; 

mail ("$email", "Birthday: MY Site", "Happy Birtday 

from ME!",$headers); 

echo "<font face=Verdana size=4 color=#FF0000>Email sent"; 


                  ?>

i also want to echo how many email were sent or if not sent.

thanks.

[devinemke]

i don't know your exact data structure but i'm going tot assume that field "NATDAT" is the person's birthdate. anyway, here's the basic idea:

$result = mysql_query ("SELECT NAME, EMAIL, NATDAT FROM table WHERE DATE_FORMAT(NATDAT, '%m-%d') = '" . date ('m-d') . "'");
while ($row = mysql_fetch_assoc ($result))
{
	extract ($row);
	$to = "$NAME <$EMAIL>";
	$from = 'from: My Website <[e-mail]>';
	$subject = 'Happy Birthday!';
	$message = "Dear $NAME, today is $NATDAT which is your birthday.";

$mail = @mail($to, $subject, $message, $from);
if ($mail) {echo 'mail sent<br>';} else {echo 'mail FAIL<br>';}
}

[sirTemplar]

thank you very much. what if i want also to put how old are they? what do i have to add? thank you so much.

[devinemke]

$result = mysql_query ("SELECT NAME, EMAIL, NATDAT, YEAR(NATDAT) AS year FROM table WHERE DATE_FORMAT(NATDAT, '%m-%d') = '" . date ('m-d') . "'");
while ($row = mysql_fetch_assoc ($result))
{
    extract ($row);
	$how_old = date ('Y') - $year;
    $to = "$NAME <$EMAIL>"; 
    $from = 'from: My Website <[e-mail]>'; 
    $subject = 'Happy Birthday!'; 
    $message = "Dear $NAME, today is $NATDAT which means that you are $how_old years old."; 

$mail = @mail($to, $subject, $message, $from);
if ($mail) {echo 'mail sent<br>';} else {echo 'mail FAIL<br>';}
}

[sirTemplar]

thanks for the reply, that was quick! there is only one thing i noticed (although not part of this post maybe) is about headers. i want to use html tags like <b> for example. when the email is read via webmail, the tags work but if i download it on outlook express the tags do not work but one can only see the html code! anyway no big deal! thanks again.

[Weedpacket]

Originally posted by sirTemplar
but if i download it on outlook express the tags do not work but one can only see the html code!

There is an example of how to send HTML email on the [man]mail[/man] manual page.