[RESOLVED] Place Message at the Bottom of Email

[transfield]

Hello,
My code below queries a database & sends the results via email. The code is working fine.

I'm now trying to place an "unsubscribe" message at the bottom of the email. No matter what I try, the "unsubscribe" message appears at top of the email. How do I make the message appear at the bottom of the email?

Thanks.

<?php
//connection to mysql database

$mktime = date('Y-m-d');

$query1=("SELECT * FROM developer_log WHERE '$mktime' < expiry ORDER BY id ASC"); 

$result1=mysql_query($query1); 
$num1=mysql_num_rows($result1);

$headers  = 'MIME-Version: 1.0' . "\r\n"; 
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; 
$headers .= 'From: [e-mail]' . "\r\n" . 
   'Reply-To: [e-mail]' . "\r\n" . 
   'X-Mailer: PHP/' . phpversion();

$subject = "Latest Approved Residential Developments";

$message_tmp  = "<h3>List of Latest Approved Residential Developments</h3>"; 
$message_tmp .= "<table bgcolor='black' cellspacing='1' width='100%'><tr bgcolor='white' align='center'>"; 
$message_tmp .= "<td><b>Year Approved</b></td>";
$message_tmp .= "<td><b>Name of Developer</b></td>"; 
$message_tmp .= "<td><b>Name of Project</b></td>"; 
$message_tmp .= "<td><b>Type of Property</b></td>"; 
$message_tmp .= "<td><b>Levels</b></td>"; 
$message_tmp .= "<td><b>Number of Units</b></td>";
$message_tmp .= "</tr>"; 
$message_tmp .= "[new_rows]"; 

while ($row1 = mysql_fetch_array($result1))
{ 
$id = $row1["id"];
$company = $row1["company"];
$project = $row1["project"];
$property = $row1["property"];
$email = $row1["email"];
$cc_email = $row1["cc_email"];

$query2= "SELECT * FROM developer WHERE date_updated < '$mktime' AND name LIKE '%{$row1['company']}%' OR development LIKE '%{$row1['project']}%' OR type LIKE '%{$row1['property']}%'"; 
$result2=mysql_query($query2);
$num2=mysql_num_rows($result2);
$new_rows = "";

while ($row2 = mysql_fetch_array($result2)) 
{ 
$new_rows .= "<tr bgcolor='white' align='center'>"; 
$new_rows .= "<td>".$row2["year"]."</td>";
$new_rows .= "<td>".$row2["name"]."</td>"; 
$new_rows .= "<td>".$row2["development"]."</td>"; 
$new_rows .= "<td>".$row2["type"]."</td>"; 
$new_rows .= "<td>".$row2["levels"]."</td>"; 
$new_rows .= "<td>".$row2["quantity"]."</td>";
$new_rows .= "</tr>";
}
	if (!empty($new_rows))
	{
	$message = str_replace("[new_rows]",$new_rows,$message_tmp); 
	mail("$email,$cc_email", $subject, $message, $headers, "[e-mail]");
	}
} 

?>

[bradgrafelman]

// ...
$message_tmp .= "<td><b>Number of Units</b></td>"; 
$message_tmp .= "</tr>"; 
$message_tmp .= "[new_rows]"; 
$message_tmp .= "<br>To unsubscribe, click <a href=\"http://mysite.com/u.php\">here</a>.";
// ...

[transfield]

Thanks for your reply, bradgrafelman. I've already tried this but the message still appears at the top of the email. A screen shot is attached. Do you have any alternative suggestions?

Thanks a lot for your guidance.

[bradgrafelman]

Ey, wait a tick, where's your ending TABLE tag? That's probably why it's displaying up there. The text is inside a TABLE tag (never closed), yet it's not in a row.

$message_tmp .= "</tr>"; 
$message_tmp .= "[new_rows]"; 
$message_tmp .= "</table><br>To unsubscribe...";

[transfield]

Yes, now it works fine. Thank you very much, bradgrafelman.

I appreciate your guidance on this matter :-)