lavede dette engang, godt nok til hunde, men det kan rettes til
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Leg med database udtræk</title>
<style type="text/css">
body {
background-color:#ffffff;
}
td {
font-family:verdana;
color:#000000;
font-size:12px;
}
a {
font-family:verdana;
color:#000000;
font-size:12px;
text-decoration:none;
}
a:hover {
font-family:verdana;
color:#000000;
font-size:12px;
font-weight:bold;
text-decoration:overline underline;
}
</style>
</head>
<body>
<table border="1" width="100%" height ="100%" style="border-collapse:collapse">
<tr>
<td width="200">
<?php
$conn = mysql_connect("localhost", "bruger", "******");
mysql_select_db("database");
#mysql_query("create table greyhound
# (id mediumint not null auto_increment,
# navn varchar(50) not null,
# far varchar(50) not null,
# mor varchar(50),
# koen varchar(10),
# primary key (id))") or die(mysql_error());
$id1 = mysql_query("SELECT DISTINCT id, navn, far, mor, koen FROM greyhound ORDER BY navn ASC");
while($id2 = mysql_fetch_array($id1)){
echo "<li><a href='?link=$id2[id]'>$id2[navn]</a></li><br>";
}
?>
</td>
<td>
<?php
if ($_GET["link"]) {
$result = mysql_query("SELECT DISTINCT id, navn, far, mor, koen FROM greyhound WHERE id = '$_GET[link]'");
while ($stam = mysql_fetch_array($result)) {
echo "<center>
<table>
<tr>
<td><strong>$stam[navn]</strong></td>
</tr>
<tr>
<td>$stam[far]</td>
</tr>
<tr>
<td>$stam[mor]</td>
</tr>
<tr>
<td>$stam[koen]</td>
</tr>
</table>
</center>";
}
} else {
echo "Vælg en hund";
}
?>
</td>
</tr>
</table>
</body>
</html>
