DB_HOST DB_USER DB_PW augsburgProbleme mit der Verbindung: Connection refusedDas Netz ist für PDB09WS/Augsburg zu prüfen. Die Datenbank ist augsburg.
//center_x: 10.905229, center_y: 48.370326, x; 10.905229, y: 48.370326
map.setCenter(new GLatLng(48.370326, 10.905229),12);
var point = new Array();
var text = new Array();
var marker = new Array();
Abfrage: SELECT stations.id , stations.longitude , stations.latitude , stations.name ,', Linie(n): ', GROUP_CONCAT(routes_stations.route_id ORDER BY routes_stations.route_id) FROM stations , routes_stations WHERE stations.id = routes_stations.station_id GROUP BY stations.id;
Die Abfrage hat Ergebniszeilen.
//Fehler bei der Ausgabe der Stops
var marker = new Array();
for (i=0; i< point.length; i++) {
marker[i] = new GMarker(point[i],icon);
map.addOverlay(marker[i]);
createListener (marker[i], text[i]);
}
Abfrage: SELECT DISTINCT routes.id , routes.colour FROM routes ORDER BY routes.id;
SELECT DISTINCT routes.id , routes.colour FROM routes ORDER BY routes.id;