html table in PHP code.

[Person]

Here is what i have.

<?php
$host = "localhost";
$user = "";
$pass = "";
$dbname = "";

$con = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);

$query= "SELECT SUM(1) AS clicks, SUM(`clcpc`), SUM(`chcpc`) FROM `nuke_pnAffiliate_clicktracking` WHERE `pl` = 'rpu' AND  `date` = '20070418'";
echo $query;

$result= mysql_query($query);
$num_results = mysql_num_rows($result);
    
$row= mysql_fetch_assoc($result);

mysql_free_result($result);

$email_to = ".com";
$email_from = ".com";
$email_title = "Total Clicks report";
$email_body =" [b][color=red][size=20pt]I WANT THE TABLE HERE[/size][/color][/b]";

mail($email_to,$email_from,$email_title,$email_body,"From:$email_from\r\nReply-To:do not reply to sever");

?>

 

and the Html code for the table

<TABLE BORDER="1" CELLPADDING="0" CELLSPACING="0" 
WIDTH="300" HEIGHT="70">

<TR>
<TD ALIGN="CENTER" COLSPAN="3" BGCOLOR="#e36328"><B>Total Clicks
</B></TD>
</TR>

<TR>
<TD ALIGN="CENTER" WIDTH="100" BGCOLOR="#1a467d"> [b][font=Verdana][size=20pt][color=red]. $phpVariable needs to come in here in the table [/color][/size][/font][/b]. </TD>


</TABLE>

</BODY>

 

$email_body =" I WANT THE TABLE HERE";

 

. $phpVariable needs to come in here in the table [/b].

[mpharo]

depending on what e-mailing class your using .... in the mail body you can use html, you just need to escape all " with a \