Buenas,
Tengo el siguiente código:
Código PHP:
<?php
mysql_connect('XXXX', 'XXXX', 'XXXX') or die('Ha habido un problema con la conexión al servidor.');
mysql_select_db('XXXXX') or die('Ha habido un problema con la conexión a la base de datos.');
$query = mysql_query("SELECT * FROM Airports") or die('No se ha podido encontrar el origen');
for($i = 0; $i < mysql_num_rows($query); $i++){
$lat = mysql_result($query, $i, 'Lat');
$lon = mysql_result($query, $i, 'Lon');
?>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<style type="text/css">
html { height: 100% }
body { height: 100%; margin: 0px; padding: 0px }
#map_canvas { height: 100% }
</style>
<script type="text/javascript"
src="http://maps.google.com/maps/api/js?sensor=false&language=es">
</script>
<script type="text/javascript">
function initialize() {
var VueloFinalizado = {
autozoom: true,
zoom: 5,
center: new google.maps.LatLng(40.84706, -2.944336),
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(document.getElementById("map_canvas"), VueloFinalizado);
var DepICAO = new google.maps.InfoWindow({
content: '<h3 align="center" style="font-family:Arial, Helvetica, sans-serif"><?php echo $lat; ?></h3>'
});
var image = 'http://mapicons.nicolasmollet.com/wp-content/uploads/mapicons/shape-default/color-d22328/shapecolor-color/shadow-1/border-dark/symbolstyle-white/symbolshadowstyle-dark/gradient-no/airport.png';
var myLatLngDep = new google.maps.LatLng(<?php echo $lat; ?>, <?php echo $lon; ?>);
var Dep = new google.maps.Marker({
position: myLatLngDep,
map:map,
icon: image,
title:"Origen"
});
var flightPlanCoordinates = [
new google.maps.LatLng(<?php echo $lat; ?>, <?php echo $lon; ?>),
];
var flightPath = new google.maps.Polyline({
path: flightPlanCoordinates,
strokeColor: "#FF0000",
strokeOpacity: 2.0,
strokeWeight: 2
});
flightPath.setMap(map);
google.maps.event.addListener(Dep, 'click', function(){
DepICAO.open(map, Dep);
});
}
</script>
</head>
<body onload="initialize()">
<center><div id="map_canvas" style="width:650px; height:360px;"></div></center>
</body>
<?php
}
Lo que yo quiero es que muestre todas las entradas de esa tabla de la base de datos pero sólo me muestra la última.