Mysql and PHP code help that sending a mail

[peterengland]

Hello I have a mysql database with filds like Name , DEPT ,and  DOB the table name is emp and database name is EMPMASTER

i have pear mail working script using gmail smtp and a Mysql query that shows todays birthday , My question is how to mix these two codes to mail output of that Mysql query in mail ? please suggest. following is the php code and my sql query.

<?php
// Pear Mail Library
require_once "Mail.php";
 
$from = '<[email protected]>';
$to = '<[email protected]>';
$subject = 'Hi!';
$body = "Hi,\n\nHow are you?";
 
$headers = array(
    'From' => $from,
    'To' => $to,
    'Subject' => $subject
);
 
$smtp = Mail::factory('smtp', array(
        'host' => 'ssl://smtp.gmail.com',
        'port' => '465',
        'auth' => true,
        'username' => '[email protected]',
        'password' => '123@123'
    ));
 
$mail = $smtp->send($to, $headers, $body);
 
if (PEAR::isError($mail)) {
    echo('<p>' . $mail->getMessage() . '</p>');
} else {
    echo('<p>Message successfully sent!</p>');
}
?>

SELECT * FROM emp WHERE MONTH(dob) = MONTH(NOW()) AND DAY(dob) = DAY(NOW());