PHPmailer: How do I display arrays?

[Jack.Straw]

I have a scenario where i'll need an email to be sent containing selected contents of a database.  I've tried building the email as a variable and then using the variable as the email body, but I can't seem to figure out how to force a carriage return.  I would like all items listed on a separate line.  Can I somehow put conditionals and loops within the body tag? 

This is the logic behind what i'm trying to do:
[code]
$result=mysql_query("SELECT * from SoldItems WHERE OrderNumber='$userID'");
while ($row=mysql_fetch_array($result)) {
  //DisplayInEmail: $row[Qty] - $row[Item];
}
[/code]

I tried doing something like:
[code]
$result=mysql_query("SELECT * from SoldItems WHERE OrderNumber='$userID'");
while ($row=mysql_fetch_array($result)) {
  $Display=$Display."$row[Qty] - $row[Item]<br>";
}
$mailer->Body = "$Display";
[/code]
... but that relies on html for the carriage return and I need the emails in plain text.


Thanks in advance for any advice you can offer!
-Jack

[kernelgpf]

HTML doesn't work in standard email, use "\n" instead.

[Jack.Straw]

Ahhhh, \n...  that's the ticket.  Thanks, that worked great!