An welchen Stationen kann man zwischen zwei gewählten Linien umsteigen?
\n";
if (array_key_exists('line1',$_GET) AND array_key_exists('line2',$_GET)) {
$line1 = $_GET['line1'];
$line2 = $_GET['line2'];
if($line1 != $line2) {
echo "Sie haben Linie $line1 und Linie $line2 gewählt.
\n";
$query1 ="SELECT s.name
FROM routes r, stops s, stopsonroutes sr
WHERE sr.rid = r.id
AND sr.sid = s.id
AND (r.id = $line1 OR r.id = $line2)
GROUP BY s.name
HAVING count(s.name)>1
ORDER BY name;";
if($query1){
$result1 = mysql_query($query1) OR die("Fehler: ". mysql_error());
echo "
\n";
echo "\t
Umsteigemöglichkeiten
\n";
while ($object = mysql_fetch_object($result1)) {
echo "\t
$object->name
\n";
}
echo "
\n";
mysql_free_result($result1);
}
} else {
echo "Sie haben die gleichen Linien gewählt.";
}
}
$querySt = "SELECT DISTINCT id FROM routes ORDER BY id";
$resultSt = mysql_query($querySt) OR die("Fehler: ". mysql_error());
if ($resultSt) {
echo "\n";
} else {
echo "Fehler: 'SELECT DISTINCT name FROM stops ORDER BY name' hat kein Ergebnis!\n";
}
mysql_close($db);
?>