<?php include("filename.php"); ?>

<?php

# db vars
$dbuser = "dbuser"; # username
$dbpass = "dbpass"; # password
$database = "dbname"; # name of database
$dbhost = "localhost"; # usually localhost

# db connect
$dbh = mysql_connect($dbhost, $dbuser, $dbpass) || die ("Unable to connect to host");
$selected = mysql_select_db($database) || die ("Unable to select database");

# query
$query="SELECT url from [[tablename]]";
$result=mysql_query($query);
$numrows = mysql_numrows($result);
$i = 0;

while ($i < $numrows) {
  $url=mysql_result($result,$i,"url");
  echo "<a href=\"$url\">$url</a><br>";
$i++;
}

?>

<?php include("mainmenu.php"); ?>