<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
       "http://www.w3.org/TR/html4/loose.dtd">
<?php
require_once('mysql.inc.php');
echo "<head>";
echo "<title>Anzeigen aller Sehenswürdigkeiten mit Beschreibung</title>";
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo "</head>";
echo "<body>";
echo "<h2>Anzeigen aller Sehenswürdigkeiten mit Beschreibung</h2>";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT name AS 'Sehenswürdigkeit', address AS 'Adresse', discription AS 'Beschreibung'
FROM sights
ORDER BY name ASC;");
while ($ds = mysqli_fetch_object($sql)){
  $name = $ds -> Sehenswürdigkeit;
  $address  = $ds -> Adresse;
  $des  = $ds -> Beschreibung;
  echo "<b>$name</b><br>$address<br>$des<br>";
  echo "";
  echo "<br>";
  }	
mysqli_close($dz);
echo "</body>";
?>
