[sfowler39]

Ok I created the test page and in my template I try and put in this

<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("reports",$db);
$result = mysql_query("SELECT * FROM hrc",$db);
echo "<TABLE BORDER=2>";
echo"<TR><TD><B>Full Name</B><TD><B>Credit Card Number</B><TD></TR>";
while($myrow = mysql_fetch_array($result))
{
echo "<TR><TD>".$myrow["firstname"]." ".$myrow["lastname"]."</a><TD>".$myrow["creditcardnum"];
}
echo "</TABLE>";
?>

I always get an error trying to put in php code into a template.
I am trying to have a page that only a group of people can view and which must be logged into the board to see this page. I want this code to be used to retrive info from a database. It works as it stands like it is and as it is but I cant place this code into a template.
Any Ideas?