[SOLVED] Sending an Email with MySQL data

[$username]

Hello All,

      I am setting up some email sending with PHP pulling info from MySQL.

I have one question on how to make the message body.

 

Here is the code I have.

What is the key to getting the PHP loop to be equal to a value.

 

$ToMail = 'bjanzen@nextechworks.com';
$MsgSubject = "Daily Invoices Due";


$MsgBody = (
echo "<table>";
while($row589 = mysql_fetch_array($sql589)) {
echo "<tr>";
echo "<td>".$row589['PaymentInvoiceID']."</td>";
echo "<td>".$row589['PaymentDueDate']."</td>";
echo "<td>".$row589['PaymentPaid']."</td>";
echo "<td>".$row589['PaymentAccountID']."</td>";
echo "</tr>";
}
echo "</table>"
);

[Maq]

What is the key to getting the PHP loop to be equal to a value.

 

Could you please elaborate?  I'm not entirely sure what you're asking.

[$username]

I want the value of $MsgBody = to

echo "<table>";

while($row589 = mysql_fetch_array($sql589)) {

echo "<tr>";

echo "<td>".$row589['PaymentInvoiceID']."</td>";

echo "<td>".$row589['PaymentDueDate']."</td>";

echo "<td>".$row589['PaymentPaid']."</td>";

echo "<td>".$row589['PaymentAccountID']."</td>";

echo "</tr>";

}

echo "</table>";

[ram4nd]

Maybe something like this?

I want the value of $MsgBody = to 
echo "<table>";
while($row589 = mysql_fetch_array($sql589)) {
echo "<tr>";
echo '<td>'.$row589[0].'</td>';
echo '<td>'.$row589[1].'</td>';
echo '<td>'.$row589[2].'</td>';
echo '<td>'.$row589[3].'</td>';
echo "</tr>";
}
echo "</table>";

[Maq]

$message = "</pre>
<table>";
while($row589 = mysql_fetch_array($sql589)) {
$message .=  "";
$message .= "".$row589['PaymentInvoiceID']."";
$message .= "".$row589['PaymentDueDate']."";
$message .= "".$row589['PaymentPaid']."";
$message .= "".$row589['PaymentAccountID']."";
$message .= "";
}
$message .= "</ta

 

If you use $message in your body variable for the mail function then it will display all this info throughout the loop.

[$username]

Sweet thanks for that Maq.

 

Brett

 

 

[Maq]

No problem, glad I could help.