Der sker et eller andet, men nu får jeg denne meldning når jeg skal have svaret ud: Unknown column 'navn' in 'order clause'
min vissvar ser sådan ud: <!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Svar tabel</title>
<meta name="Generator" content="Stone's WebWriter 4">
</head>
<body>
<?php
mysql_connect("192.168.1.3", "ferieitalien", "nannas") or die(mysql_error());
mysql_select_db("ferieitalien") or die(mysql_error());
$svar = mysql_query("SELECT * FROM mindb ORDER BY navn ASC") or die(mysql_error());
print "<table border=1>";
while ($row = mysql_fetch_array($svar))
{
print "<tr><td>Navn</td>
<td>".$row["name"]."</td></tr>
<tr><td>Steetno</td>
<td>".$row["streetno"]."</td></tr>
<tr><td>zip</td>
<td>".$row["zip"]."</td></tr>
<tr><td>city</td>
<td>".$row["city"]."</td></tr>
<tr><td>country</td>
<td>".$row["country"]."</td></tr>
<tr><td>telephone</td>
<td>".$row["telephone"]."</td></tr>
<tr><td>mail</td>
<td>".$row["mail"]."</td></tr>
<tr><td>weeks</td>
<td>".$row["weeks"]."</td></tr>
<tr><td>Nopeople</td>
<td>".$row["nopeople"]."</td></tr>
<tr><td>Adults</td>
<td>".$row["noadults"]."</td></tr>
<tr><td>Nochildren</td>
<td>".$row["nochildren"]."</td></tr>
<tr><td>Startdate</td>
<td>".$row["startdate"]."</td></tr>
<tr><td>startmonth</td>
<td>".$row["startmonth"]."</td></tr>
<tr><td>startyear</td>
<td>".$row["startyear"]."</td></tr>
<tr><td>enddate</td>
<td>".$row["enddate"]."</td></tr>
<tr><td>endmonth</td>
<td>".$row["endmonth"]."</td></tr>
<tr><td>endyear</td>
<td>".$row["endyear"]."</td></tr>
<tr><td>remarks</td>
<td>".$row["remarks"]."</td></tr>
<tr><td colspan=\"2\"> </td></tr>";
}
print "</table>";
?>
</body>
</html>
