[simon157]

Hi, could someone please, please help me as I'm struggling adding code containing php code to my template. It's driving me nuts !! The code I want to add is the following so it loads within the forum environment, but I'm completely stuck...

PHP Code:

<?php require_once('Connections2/databasecon.php'); ?>
<?php
$maxRows_usersightings = 15;
$pageNum_usersightings = 0;
if (isset($_GET['pageNum_usersightings'])) {
  $pageNum_usersightings = $_GET['pageNum_usersightings'];
}
$startRow_usersightings = $pageNum_usersightings * $maxRows_usersightings;

mysql_select_db($database_databasecon, $databasecon);
$query_usersightings = "SELECT * FROM sightings ORDER BY id DESC";
$query_limit_usersightings = sprintf("%s LIMIT %d, %d", $query_usersightings, $startRow_usersightings, $maxRows_usersightings);
$usersightings = mysql_query($query_limit_usersightings, $databasecon) or die(mysql_error());
$row_usersightings = mysql_fetch_assoc($usersightings);

if (isset($_GET['totalRows_usersightings'])) {
  $totalRows_usersightings = $_GET['totalRows_usersightings'];
} else {
  $all_usersightings = mysql_query($query_usersightings);
  $totalRows_usersightings = mysql_num_rows($all_usersightings);
}
$totalPages_usersightings = ceil($totalRows_usersightings/$maxRows_usersightings)-1;
?>
<div id="container">
<div style="padding-left: 10px; padding-top:5px;">
  <a href="index.php?pageid=sightingssubmit.php"><strong>Submit a sighting </strong></a> | <a href="index.php?pageid=Sightings.php"><strong>Show all sightings   </strong></a>|                           <a href="index.php?pageid=Sightings.php&<?php printf("%spageNum_usersightings=%d%s", $currentPage, max(0, $pageNum_usersightings - 1), $queryString_usersightings); ?>">Previous</a> | <span class="style55"><a href="index.php?pageid=Sightings.php&<?php printf("%spageNum_usersightings=%d%s", $currentPage, min($totalPages_usersightings, $pageNum_usersightings + 1), $queryString_usersightings); ?>">Next</a>
              
              <span class="style55">              </div>
<br />
<table width="95%" border="0" align="center" bgcolor="#FCFCFC">
<tr>
               <td bgcolor="#848E7B"><div align="left" class="style1">No.</div></td>
      <td bgcolor="#848E7B"><div align="left" class="style1">Species</div></td>
      <td bgcolor="#848E7B"><div align="left" class="style1">Date</div></td>
      <td bgcolor="#848E7B"><div align="left" class="style1">Location</div></td>
      <td bgcolor="#848E7B"><div align="left" class="style1">Recorder</div></td>
      <td bgcolor="#848E7B"><div align="left" class="style1">Details</div></td>
    </tr>
             <?php do { ?>
               <tr>
                 <td width="30" valign="top" bgcolor="#FFFff4"><div align="left" class="style131 "> <?php echo $row_usersightings['id']; ?></div></td>
                 <td width="150" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['species']; ?></div></td>
                 <td width="50" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['date']; ?></div></td>
                 <td width="120" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['location']; ?></div></td>
                 <td width="100" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['recorder']; ?></div></td>
                 <td width="350" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"><?php echo $row_usersightings['Notes']; ?></div></td>
             </tr>
               <?php } while ($row_usersightings = mysql_fetch_assoc($usersightings)); ?>
    </table>
</div>

Hope you can help

Simon