Create("triumphstag_db"); // Include the header file include ("../../include/header.php"); // set default buttons for this page //$btitle ="<- Back"; //$blink = "../"; //include ("../include/button.php"); //$target ="main"; // create the start of a table and add links to it echo(""); echo(""); echo(""); // get urls from the table $sql->Query("Select heading,text,url,datestamp from stagdatalinks where section ='supplier' order by heading"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $title = $sql->data[0]; $text = $sql->data[1]; $url = $sql->data[2]; $date= $sql->data[3]; //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(""); } echo("

* Add Link to list *

$icon title=""$title

"); ?>