Código PHP:
Ver originalinclude ('cabecera.php');
function mostrar(){
$enlace="2012-03-11";
mysql_connect("localhost","root","78247824") or die("Problemas en la conexion");
mysql_select_db("mialgicos") or die("Problemas en la seleccion de la base de datos");
$sql="SELECT deporte FROM $_COOKIE[usuario] WHERE dia='$enlace'" or die("Problemas en el select");
$query=mysql_query($sql);
while($reg=mysql_fetch_assoc($query)){
if ($reg['deporte']=='Other'){
$Calendario['Other'][] = "<img src='../img/swimming.gif'>";
}
if ($reg['deporte']=='Biking'){
$Calendario['Biking'][] = "<img src='../img/cicles.gif'>";
}
if ($reg['deporte']=='Running') {
$Calendario['Running'][] = "<img src='../img/running.gif'>";
}
}
return $Calendario;
}
$Calendario = mostrar();
?>
<table>
<!-- Calendario de otros deportes -->
<? foreach($Calendarios['Other'] as $field ):?>
<tr><td><?=$field?></td></tr>
<?php endforeach; ?>
<!-- Calendario de Biking deportes -->
<? foreach($Calendarios['Biking'] as $field ):?>
<tr><td><?=$field?></td></tr>
<?php endforeach; ?>
<!-- Calendario de Running deportes -->
<? foreach($Calendarios['Running'] as $field ):?>
<tr><td><?=$field?></td></tr>
<?php endforeach; ?>
</table>