Her er koden til siden
http://www.unj.dk/index.php?side=epoke3.liste.select.php<h1>Epoke III liste - senest opdateret: 25. marts 2007</h1>
<p>For at vise hele listen, klik på dette link: <a href="index.php?side=epoke3.liste.php">Epoke III liste</a>
<?
include("inc.config.php");
$database = "unj_dk";
$query = "select distinct(year) from epoke3 order by year";
$result = mysql_db_query($database, $query, $connection);
?>
<table>
<br>
<form method="post" action="index.php?side=epoke3.liste.year.php">
<p>Vælg et årstal og klik på 'Vis' for at vise alle modeller fra det årstal:</p>
<br>
<?
if(mysql_num_rows($result) > 0)
{
echo "<select name = year>";
while($row = mysql_fetch_array($result))
{
$year= $row['year'];
echo "<option value='$year'>$year";
}
echo "</option>";
echo "</select>";
}
echo "<input type=Submit name=trykknap value=Vis>";
echo "</form>";
echo "</table>";
?>
<?
include("inc.config.php");
$database = "unj_dk";
$query = "select distinct(make) from epoke3";
$result = mysql_db_query($database, $query, $connection);
?>
<table>
<br>
<form method="post" action="index.php?side=epoke3.liste.make.php">
Vælg et bilmærke og klik på 'Vis' for at vise alle modeller fra det bilmærke:
<br>
<?
if(mysql_num_rows($result) > 0)
{
echo "<select name = make>";
while($row = mysql_fetch_array($result))
{
$make= $row['make'];
echo "<option value='$make'>$make";
}
echo "</option>";
echo "</select>";
}
echo "<input type=Submit name=trykknap value=Vis>";
echo "</form>";
echo "</table>";
?>
<?
include("inc.config.php");
$database = "unj_dk";
$query = "select distinct(producent) from epoke3 order by producent";
$result = mysql_db_query($database, $query, $connection);
?>
<table>
<br>
<form method="post" action="index.php?side=epoke3.liste.producent.php">
<br>
Vælg en producent og klik på 'Vis' for at vise alle modeller fra den fremstiller:
<br>
<?
if(mysql_num_rows($result) > 0)
{
echo "<select name = producent>";
while($row = mysql_fetch_array($result))
{
$producent= $row['producent'];
echo "<option value='$producent'>$producent";
}
echo "</option>";
echo "</select>";
}
echo "<input type=Submit name=trykknap value=Vis>";
echo "</form>";
echo "</table>";
?>
<br>
</body>