[Lynne]

Basically, you want to put this in your page:

PHP Code:

require_once('Connections2/databasecon.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; 

$newTemplate = vB_Template::create('your_template');
    $newTemplate->register('row_usersightings', $row_usersightings);
$newTemplate->render(); 


And this in your template your_template:

<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&*something_here*">Previous</a> | <span class="style55"><a href="index.php?pageid=Sightings.php&*something_here*">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 "> {vb:raw row_usersightings.id}</div></td> 
                 <td width="150" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.species}</div></td> 
                 <td width="50" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.date}</div></td> 
                 <td width="120" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.location}</div></td> 
                 <td width="100" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.recorder}</div></td> 
                 <td width="350" valign="top" bgcolor="#FFFff4"><div align="left" class="style131">{vb:raw row_usersightings.Notes}</div></td> 
             </tr> 
               *something here*
    </table> 
</div>

That is just some of the basics. I didn't do anything with the other php code you had in the middle of your html - you'll need to put that in the php page like all the other stuff, but this is the basics of what to put into the other page you started with the article. If you need someone to do the whole thing for you, you may want to post in Paid Services.