How to include a while loop with email

[Anon]

Hi there,

I have a bunch of names in a database and I'd like to send them in the body of an email. What I have is below. As you can see there is a while loop in the body, however this doesn't work. Could someone please send me a way to do this. Thanks!

$sql = "SELECT name FROM names";
@mysql_select_db($DBName,$link_id);
$result=mysql_query($sql);

MAIL(
"[e-mail]",
"TEST SUBJECT HEADER",
"
body of the email goes here...

while ($line=mysql_fetch_array($result)) {
$line[name];
}

",
"From: $email\nX-Mailer: PHP/" . phpversion()
);

mysql_close($link_id);

[Anon]

This should work. Email me if you don't understand it. I divided the tasks up instead of creating the list of names in the mail function, I created a variable to store the names as a string then used that in the mail function. It is a bit easier to understand that way.

sql = "SELECT name FROM names";
@mysql_select_db($DBName,$link_id);
$result=mysql_query($sql);

// $names = a string of all names returned from SQL statement
$names = ""; // intialize it to be empty;

// store names from database into the a string
// each name is seperated by a comma
while ($line=mysql_fetch_array($result))
{
// if names string is empty, just store the name without a comma
if( $names != "" )
$names .= $line[name];

// else, seperate names with commas
else
$names .= ", " . $line[name];
}

// append names to the body text
$body = "BODY TEXT HERE " . $names . " MORE BODY TEXT AFTER NAMES";

// send the email
MAIL(
"[e-mail]",
"TEST SUBJECT HEADER", $names,
"From: $email\nX-Mailer: PHP/" . phpversion()
);

mysql_close($link_id);

[Anon]

while ($line=mysql_fetch_array($result)) {
$name = $line["name"];
$newmessage.="Name of a person is: ";
$newmessage.=$name;
$newmessage.=" \n"; //line break
}

MAIL("[e-mail]", "TEST SUBJECT HEADER", " body of the email goes here...
my names are as follows:
$newmessage

I hope you like these. ", "From: $email\nX-Mailer: PHP/" . phpversion() );

you can add to the $newmessage variable to format it however you like. hope this helps.
stuart