I am using Zend mail to send an email to people on their birthdays.

On my php page, I query my mySQL database and form an array of information:

Code:
mysql_select_db($database_connect, $connect);
$query_contacts = "SELECT Birthdate, contacts.First, contacts.Last, contacts.Email, contacts.Patient_Number AS Number, contacts.Patient_ID
FROM contacts 
WHERE contacts.Active = 'Y'
AND contacts.Company_ID = '1'
AND contacts.Birthday_Email = 'Y'
AND contacts.Email LIKE '%@%'
HAVING MONTH(Birthdate) = MONTH(CURDATE()) AND DAY(Birthdate) = DAY(CURDATE())
";
$contacts = mysql_query($query_contacts, $connect) or die(mysql_error());
$totalRows = mysql_num_rows($contacts);

$emailBody = "";

while($row_contacts = mysql_fetch_assoc($contacts))
{
    $config = array('auth' => 'login', 'port' => 25, 'username'=> '[email protected]', 'password'=>'password');	
	$transport = new Zend_Mail_Transport_Smtp('[email protected]', $config);
	
 
    $arr_ids[] = $row_contacts['Patient_ID'];

....

code to send email via Zend mail goes here

....

}
The array, $arr_ids[], that stores Patient_IDs.... I'd like to send all the values in an email to me next so I can see who was emailed.

Here's some of the code that I am using for the body of the email:

Code:
$body2 = "<font size='2' face='arial' color='black'>Hello, this is an automatic update.<br><br>We sent " . $totalRows  . "  emails to say 'Happy Birthday!' today.</font><br><br>";
I want to have all the IDs listed in the email. How do I get that from the array and then insert it into the body of my php email?

Thanks.