DB_HOST DB_USER DB_PW erfurtProbleme mit der Verbindung: Connection refusedDas Netz ist für PDB10SS/Erfurt zu prüfen. Die Datenbank ist erfurt.
//center_x: 11.0245864, center_y: 50.9777281, x; 11.0245864, y: 50.9777281
map.setCenter(new GLatLng(50.9777281, 11.0245864),12);
var point = new Array();
var text = new Array();
var marker = new Array();
Abfrage: SELECT stops.id , stops.lon , stops.lat , stops.name ,', Linie(n): ', GROUP_CONCAT(stops_on_routes.route_id ORDER BY stops_on_routes.route_id) FROM stops , stops_on_routes WHERE stops.id = stops_on_routes.stop_id GROUP BY stops.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.hexcolor FROM routes ORDER BY routes.id;
SELECT DISTINCT routes.id , routes.hexcolor FROM routes ORDER BY routes.id;