<!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>Tarife auch außerhalb Göttingens</title>";
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo "</head>";
echo "<body>";
echo "<h2>Tarife auch außerhalb Göttingens</h2>";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT name AS 'Tarif', comments AS 'Beschreibung', surroundings AS 'Preis'  
FROM rates
ORDER BY name ASC;");
while ($ds = mysqli_fetch_object($sql)){
  $tarif = $ds -> Tarif;
  $des = $ds -> Beschreibung;
  $price = $ds -> Preis;
  echo "<b>$tarif</b><br>";
  echo "$des<br>";
  echo "<b>Preis:</b> $price €";
  echo "<br><br>";
  }	
mysqli_close($dz);
echo "</body>";
?>
