Email list from mysql

[nealec]

I am trying to send a list of every name in a database via email but everything i have tried just sends lots of emails with a different name in each email. How can i send every name in one email?

[MasterACE14]

can you post your code?

[nealec]

This just sends me multiple emails with a different name in each one rather than all the names in one email.

 

<?php

$servername="*******";
$username="*******";
$password="*******";
$conn=  mysql_connect($servername,$username,$password)or die(mysql_error());
mysql_select_db("*******",$conn);			

$result = mysql_query("SELECT name FROM people WHERE mail='yes' ");
while($row = mysql_fetch_array($result)){

$to = "[email protected]";
		$subject = "People names";
		$body = "This is a list of all names in database.

$row[name]";
		mail($to, $subject, $body);
		}
?>