";
echo "Anzahl der haltenden Linien an einer Station";
echo "";
echo "";
echo "";
echo "Anzahl der haltenden Linien an einer Station
| Haltestelle |
Anzahl Linien |
";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT stations.name AS 'Haltestelle', COUNT( statline.idstations ) AS 'AnzahlLinien'
FROM statline, stations
WHERE statline.idstations = stations.id
GROUP BY statline.idstations
HAVING count( statline.idstations ) >1
ORDER BY 1;
");
while ($ds = mysqli_fetch_object($sql)){
$station = $ds -> Haltestelle;
$count = $ds -> AnzahlLinien;
echo
"
";
}
mysqli_close($dz);
echo "";
?>