DB_HOST DB_USER DB_PW bruesselProbleme mit der Verbindung: Connection refusedDas Netz ist für PDB11WS/Bruessel zu prüfen. Die Datenbank ist bruessel.
//center_x: 4.3491532, center_y: 50.8478047, x; 4.3491532, y: 50.8478047
map.setCenter(new GLatLng(50.8478047, 4.3491532),12);
var point = new Array();
var text = new Array();
var marker = new Array();
Abfrage: SELECT tramstop.s_id , tramstop.lng , tramstop.lat , tramstop.name ,', Linie(n): ', GROUP_CONCAT(routestop.r_id ORDER BY routestop.r_id) FROM tramstop , routestop WHERE tramstop.s_id = routestop.s_id GROUP BY tramstop.s_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 routecolor.r_id , routecolor.hexcolor FROM routecolor ORDER BY routecolor.r_id;
SELECT DISTINCT routecolor.r_id , routecolor.hexcolor FROM routecolor ORDER BY routecolor.r_id;