\n";
echo "\n";
//Table lines ordered by distance
echo "\n";
echo "\n";
echo "\t| Liniennummer | Streckenlänge |
|---|
\n";
$query1 = "SELECT id, MAX(distance) AS maxdistance FROM stopsonroutes, routes WHERE routes.id = stopsonroutes.rid GROUP BY id ORDER BY MAX(distance)";
$sth1 = mysql_query($query1) OR die("Fehler: ". mysql_error());
$count1 = 0;
$dist1 = 0;
while ($object = mysql_fetch_object($sth1)) {
//counts the number of rows of results (number of routes)
$count1=$count1+1;
//counts all maxdistances of all routes
$dist1=$dist1+$object->maxdistance;
echo "\t| $object->id | $object->maxdistance |
\n";
}
echo "
\n";
$avg1 = round($dist1/$count1);
echo "Die Streckenlänge zwischen zwei Stationen beträgt durchschnittlich $avg1 m.
\n";
mysql_free_result($sth1);
//Table lines ordered by time
echo "\n";
echo "\n";
echo "\t| Liniennummer | Fahrzeit |
|---|
\n";
$query2 = "SELECT id, MAX(duration) AS maxduration FROM stopsonroutes, routes WHERE routes.id = stopsonroutes.rid GROUP BY id ORDER BY MAX(duration)";
$sth2 = mysql_query($query2) OR die("Fehler: ". mysql_error());
$count2 = 0;
$dist2 = 0;
while ($object = mysql_fetch_object($sth2)) {
$count2 = $count2+1;
$dist2 = $dist2+$object->maxduration;
echo "\t| $object->id | $object->maxduration |
\n";
}
echo "
\n";
$avg2=round($dist2/$count2);
echo "
\n";
//Die Fahrzeit der Linien beträgt durchschnittlich $avg2 min.
mysql_free_result($sth2);
//table ordered by number of stops
echo "\n";
echo "\n";
echo "\t| Liniennummer | Haltestellenanzahl |
|---|
\n";
$query3 = "SELECT count(stopsonroutes.sid) AS count, routes.id AS line
FROM stopsonroutes, routes
WHERE stopsonroutes.rid=routes.id
GROUP BY stopsonroutes.rid
ORDER BY count(stopsonroutes.sid);";
$sth3 = mysql_query($query3) OR die("Fehler: ". mysql_error());
$count3=0;
$dist3=0;
while ($object = mysql_fetch_object($sth3)) {
$count3=$count3+1;
$dist3=$dist3+$object->count;
echo "\t| $object->line | $object->count |
\n";
}
echo "
\n";
$avg3=round($dist3/$count3);
echo "Die durchschnittliche Haltestellenanzahl der Linien beträgt $avg3.\n";
mysql_free_result($sth3);
echo "\n";
mysql_close($db);
?>