";
echo "Welches ist die längste und welches die kürzeste Linie?";
echo "";
echo "";
echo "";
echo "Welches ist die längste und welches die kürzeste Linie?
";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT line.name AS 'Linie', statline.ridetime AS 'FahrtzeitinMinuten'
FROM line, statline
WHERE statline.ridetime = (
SELECT max( statline.ridetime )
FROM statline )
AND line.id = statline.idline
UNION SELECT line.name, statline.ridetime
FROM line, statline
WHERE statline.ridetime = (
SELECT max( statline.ridetime )
FROM statline
GROUP BY idline
ORDER BY 1
LIMIT 0 , 1 )
LIMIT 0 , 2;");
while ($ds = mysqli_fetch_object($sql)){
$name = $ds -> Linie;
$ridetime = $ds -> FahrtzeitinMinuten;
echo "$name
";
echo "Fahrzeit: $ridetime in Minuten";
echo "
";
}
mysqli_close($dz);
echo "";
?>