php kısmı
<html>
<body>
<?
mysql_connect('localhost','root','');
mysql_select_db('test') or die(mysql_error());
$SQL=mysql_query("SELECT * FROM link");
while($Link=mysql_fetch_array($SQL)){
echo '<a href="https://www.r10.net/php/'.$Link['adress'].'">'.$Link['name'].'</a><br><br>';
}
?>
</body>
</html>Veri tabanı
CREATE TABLE `link` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`adress` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=3 ;
--
-- Tablo döküm verisi `link`
--
INSERT INTO `link` VALUES (1, 'name1', 'adres1');
INSERT INTO `link` VALUES (2, 'name2', 'adres2');