$message = 'Bonjour '. $data['nom'].' '. $data['prenom'] .'! Toute la team vous souhaite un très bon anniversaire!';

//Boucle envoie mail
while ($data = $resultat->fetch_assoc())
	{ 
     $to      = $data['email'];
     $subject = 'Bon anniversaire';
     $message = 'Bonjour ' $data['nom'] ' ' $data['prenom'] '! Toute la team vous souhaite un très bon anniversaire!';
     $headers = 'From: [email protected]' . "\r\n" .
     'Reply-To: [email protected]' . "\r\n" .
     'X-Mailer: PHP/' . phpversion();
 
     mail($to, $subject, $message, $headers);
 	}

<?php
require 'PHPMailerAutoload.php';

$mail = new PHPMailer;

//$mail->SMTPDebug = 3;                               // Enable verbose debug output

$mail->isSMTP();                                      // Set mailer to use SMTP
$mail->Host = 'smtp1.example.com;smtp2.example.com';  // Specify main and backup SMTP servers
$mail->SMTPAuth = true;                               // Enable SMTP authentication
$mail->Username = '[email protected]';                 // SMTP username
$mail->Password = 'secret';                           // SMTP password
$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
$mail->Port = 587;                                    // TCP port to connect to

$mail->setFrom('[email protected]', 'Mailer');
$mail->addAddress('[email protected]', 'Joe User');     // Add a recipient
$mail->addAddress('[email protected]');               // Name is optional
$mail->addReplyTo('[email protected]', 'Information');
$mail->addCC('[email protected]');
$mail->addBCC('[email protected]');

$mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
$mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name
$mail->isHTML(true);                                  // Set email format to HTML

$mail->Subject = 'Here is the subject';
$mail->Body    = 'This is the HTML message body <b>in bold!</b>';
$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

if(!$mail->send()) {
    echo 'Message could not be sent.';
    echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
    echo 'Message has been sent';
}
?>

<?php

$date_jour = date("d/m");
     
// Déclaration des paramètres de connexion
$host = localhost;
$user = ' ';
$bdd = ' ';
$passwd  = ' ';
 
// Connexion au serveur
mysql_connect($host,$user,$passwd) or die("erreur de connexion au serveur:" . mysql_error());
mysql_select_db($bdd) or die("erreur de connexion a la base de donnees: " . mysql_error());
 
$retour = mysql_query('SELECT nom, prenom, email FROM Anniversaire WHERE MONTH(dateanniv) = MONTH(CURRENT_DATE) AND DAY(dateanniv) = DAY(CURRENT_DATE)');
while ($data = mysql_fetch_assoc($retour))
{
	//On affiche les informations de l'enregistrement en cours
	echo '<b>'.$data['nom'].' '.$data['prenom'].' '.$data['email'].'</b>';
}

//On ferme la connexion à MySQL
mysql_close();


?>