<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Timon-Links</title>
<meta http-equiv="content-type"
content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffcc66" link="#000099" vlink="#000099"
alink="#000099">
<br>
<?php
$host = "localhost";
$dbname = "book";
$user_id = "xxxx";
$user_pass = "xxxx";
//connect to database
mysql_pconnect($host, $user_id, $user_pass) or die ('no connection');
mysql_select_db($dbname) or die ('no db');
$query = "SELECT kat FROM books order by kat asc";
$result = mysql_query($query);
?>
<table width="700" border="2" cellspacing="0" cellpadding="0">
<?
while ($r = mysql_fetch_array($result)) {
?>
echo "<tr><td>$r['kat']</td></tr>"
<?
}
mysql_close();
?>
</table>
</body>
</html>
Lesezeichen