How to get this PHP code into a template

[LWillmann]

What if you assign the HTML to a variable in your code above, in the if statement, then just place a reference to the variable name in the template where you want it.

PHP Code:

<?php
require ('auth.php');  

$res = mysql_query("SELECT * FROM TableName",$db);  
$test = 1; 

if($rad = mysql_fetch_array($res))  
{  
    $output = ' <table width="642" border="0" cellspacing="0">
    <tr bordercolor="#CCFF33"> 
        <td width="XX"><strong>Topic 1</strong></div></td> 
        <td width="XX"><strong>Topic 2</strong></div></td> 
      </tr> 
      '; 
      do {  
         $output .= '<tr bordercolor="#CCFF33"> 
                 <td background="XXX.jpg">'.$test.'</td>  
                 <td background="XXX.jpg">'.$rad["Topic 1"].'</td>          
                <td background="XXX.jpg">'.$rad["Topic 2].'</td> 
                </tr>\n'; 
               $test ++; 
             }  
             while ($rad = mysql_fetch_array($res));  
              $output .= "</table>\n";  
          }
else
{
  $output = "";
}
?>

Then in your temaplate, you should be able to call a reference to $output and it will hopefully work for you. This should at least be a start in the right direction.