// connect to database
require("../../include/sqlcon.php");
$sql = new MySQL_class;
$sql->Create("triumphstag_db");
// Include the header file
include ("../../include/header.php");
echo("
");
echo("
");
echo("
");
echo("
");
// create the start of a table and add links from the registry to it
echo ("
From The Registry
");
echo("
");
echo("
");
// get urls from registry
$sql->Query("Select name, homepage,datestamp from stagdata where status <> 'deleted' and homepage <> NULL or homepage <> '' order by name");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$name = $sql->data[0];
$homepage = $sql->data[1];
$date= $sql->data[2];
//assemble each row of the table
//check row colour and alternate
if (1==$rowcolour){
$bgcolour="bgcolor='#FFFFFF' bordercolor='#FFFFFF'";
$rowcolour=0;
} else {
$bgcolour="bgcolor='#F4F4F4' bordercolor='#F4F4F4'";
$rowcolour=1;
}
if ($date >(time() - 2592000)) {
$icon = "";
} else {
$icon="";
}
echo("