Script virker ikke
Det her script virker ikke... Har et view der bestaar af to kolonner. 1: DoorId, 2: DoorNameHvis jeg korer en "SELECT * FROM DoorsView" fra en query editor, faar jeg hvad jeg skal have.
Dornummer - Dornavn
1 Dor 1
2 Dor 2
3 Dor 3
Er der noget galt med nedenstaaende?
<?php
error_reporting(0);
include( "config/config.php" );
$sql = "SELECT * FROM DoorsView ORDER BY DoorId";
$conn = odbc_connect($DSN,$db_login,$db_pw);
$res = odbc_exec($conn,$sql);
include ("conn.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta http-equiv="pragma" content="no-cache">
<title>Zone Census - Doors</title>
</head>
<body>
<p align="center"><img border="0" src="header.jpg" width="768" height="101"><br>
<br><b><font size="4">DOORS</font></p></b>
</p>
<div align="center">
</div>
<table width=600px align=center border=0>
<tr><td colspan=3><hr></td></tr>
<?php
$rows = odbc_num_rows($res);
if ($rows > 0) {
for ($n = 0; $n < $rows; $n++ ) {
$item = odbc_fetch_array($res);
echo "<tr><td colspan=2>$item[DoorId] $item[DoorName]</td></tr>\n";
}
echo "<tr><td colspan=3><hr></td></tr>";
} else {
echo "<script type=\"text/javascript\"> alert(\"No doors.\"); </script>";
}
odbc_close($conn);
?>
</table>
</body>
</html>
