<?
include "db_connection.php";   //Includes mysql connection information
?>
<?php
//Connect To Database

$dbname="wcdatabase";

// setting up the database link
$dblink = mysql_connect($dbhostname,$dbusername, $dbpassword) OR DIE ("Unable to connect to database! Please try again later.");

mysql_select_db($dbname, $dblink);

$id = 1;

// setting up the database query 
$query1 = "SELECT * FROM wcdatabase ORDER by addeddate DESC LIMIT 10";

// querying the database
$result1 = mysql_query($query,$dblink);


    
     echo "<table>";
     echo "<tr><td><b>Name: </b><td><b>ID#</b><td><b>Added Date:</b></tr>";
     
        while($row = mysql_fetch_array($result1))
    {
    
       echo "<tr><td>";
       echo $row["camname"];
       echo "<td>";
       echo $row["id"];
       echo "<td>";
       echo $row["addeddate"];
       echo "<td>";
       
    $ttcamid = $row["id"];
    $ttcamname = $row["camname"];
    $ttaddeddate = $row["addeddate"];
    
$query2 = "UPDATE wctopten SET ttcamname = "$ttcamname", ttaddeddate = "$ttaddeddate", ttcamid = "ttcamid" where ttid = $id";
$result2 = mysql_query($query2,$dblink);

        echo "<td>";
        echo $ttcamname;
        echo "<td>";
        echo $ttaddeddate;
        echo "<td>";
        echo $ttcamid;
        echo "<td><td>";
        echo $id;
        echo "<td>";

// increment the database
 $id++;

    }
    echo "</table>";

?>