<?php
include("config.php");
$PageTitel = "Adressen verwalten";
include("tabtop.php");

$verbindung = OpenDB();
$ergebnis = MyQuery("SELECT * FROM adr ORDER BY Bezeichnung");
echo '<table class="table">';
echo "<tr>";
echo "<th>ID</th>";
echo "<th>Bezeichnung</th>";
echo "<th>Firma</th>";
echo "<th>Name</th>";
echo "<th>Telefon</th>";
echo "<th>Mobil</th>";
echo "<th>E-Mail</th>";
echo "<th>Internet</th>";
echo "<th>GebDatum</th>";
echo "<th>Bemerkung</th>";
echo "</tr>\n";
while ($zeile = MyFetchArray($ergebnis))
{
	echo "<tr>";
	echo "<td>". GetField($zeile, "ID") . "</td>";
	echo "<td>". GetField($zeile, "Bezeichnung") . "</td>";
	echo "<td>". GetField($zeile, "Firma") . "</td>";
	echo "<td>". GetField($zeile, "Name") . "</td>";
	echo "<td>". GetField($zeile, "Telefon") . "</td>";
	echo "<td>". GetField($zeile, "Mobil") . "</td>";
	echo "<td>". GetField($zeile, "EMail") . "</td>";
	echo "<td>". GetFieldHandbuch($zeile, "Internet") . "</td>";
	echo "<td>". GetField($zeile, "GebDatum") . "</td>";
	echo "<td>". GetField($zeile, "Bemerkung") . "</td>";
	echo "</tr>\n";
}
echo "</table>";

MyFreeResult( $ergebnis );

?>