How to send multiple records from db to email address

[roexecom]

Hi

I want to send few records from a database to an email address

Each records should be a table <tr>

Please help me on this

Thanck you

Emilian Anghel

[Admin]

can you give some more details? like your table design & what information you want to send.

[roexecom]

I have a shopping cart, and i need to send the cart content to an email address, and each product should be a <tr> from the table.

I have already done this

PHP Code:

<?
include("admin/connect.php");
$sql="select * from cl_entries";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs))
{
  $content=$row["EntryName"];

  $count=count($content);

  for($i=0; $i<$count; $i++)
  {
    $txt=$content;
    echo $content;
  }
}

$email="emilian_anghel@yahoo.com";
$sub="Test!";

$m=mail($email, $sub, $txt);
?>

Now i don't know what to do next. This one send only one record, the last one.

Help me on this please

Thanck you

Emilian Anghel

[teknomage1]

Change '$txt = $content;' to '$txt += $content . "\n";'