<!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>Gesamtzahl der Haltestellen</title>";
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo "</head>";
echo "<body>";
echo "<h2>Gesamtzahl der Haltestellen</h2>";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT COUNT(name) AS 'AnzahlStationen'
FROM stations;");
while ($ds = mysqli_fetch_object($sql)){
  $count = $ds -> AnzahlStationen;
  echo "Es gibt <b>$count</b> Haltestellen in G&ouml;ttingen";
  echo "<br>";
  }	
mysqli_close($dz);
echo "</body>";
?>
