<!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>Alle Linien in der jeweiligen Farbe</title>";
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo "</head>";
echo "<body>";
echo "<h2>Alle Linien in der jeweiligen Farbe</h2>";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT name AS 'Linie', color AS 'Farbe', hexa
FROM line
ORDER BY 'Linie' ASC;");
while ($ds = mysqli_fetch_object($sql)){
  $name = $ds -> Linie;
  $color = $ds -> Farbe;
  $hexa  = $ds -> hexa;
  echo 
  "<table border=0>
  <tr>
  <td width=70 height=20><b>$name</b></td>
  <td width=70 height=20 bgcolor=$hexa><font color=white>$color</font></td>
  </tr>
  </table>";
}	
mysqli_close($dz);
echo "</body>";
?>
