DiaFecha |
Desa |
Col1 |
Almuerzo |
Col2 |
Merienda |
Col3 |
Cena |
Col4 |
Actividad |
include ("conectar.php");
$CONEC=mysqli_connect($HOST,$USER,$CONT,$DB);
$num=1;
while($num <30 )
{
$usua=mysqli_query($CONEC,"select * from lea where fecha = '$num' ");
while($usuario = mysqli_fetch_array($usua))
{
if($usuario[desa]==""){$desa="nadaa.jpg";} else {$desa="$usuario[desa]";}
if($usuario[almu]==""){$almu="nadaa.jpg";} else {$almu="$usuario[almu]"; }
if($usuario[meri]==""){$meri="nadaa.jpg";} else {$meri="$usuario[meri]"; }
if($usuario[cena]==""){$cena="nadaa.jpg";} else {$cena="$usuario[cena]"; }
if($usuario[col1]==""){$col1="nadaa.jpg";} else {$col1="$usuario[col1]";}
if($usuario[col2]==""){$col2="nadaa.jpg";} else {$col2="$usuario[col2]"; }
if($usuario[col3]==""){$col3="nadaa.jpg";} else {$col3="$usuario[col3]"; }
if($usuario[col4]==""){$col4="nadaa.jpg";} else {$col4="$usuario[col4]"; }
$acti="$usuario[acti]";
//----dias---
switch ($num) {
case 1: $dia= "Martes
09/02"; break;
case 2: $dia= "Miercoles
10/02"; break;
case 3: $dia= "Jueves
11/02"; break;
case 4: $dia= "Viernes
12/02"; break;
case 5: $dia= "Sabado
13/02"; break;
case 6: $dia= "Domingo
14/02"; break;
case 7: $dia= "Lunes
15/02"; break;
case 8: $dia= "Martes
16/02"; break;
case 9: $dia= "Miercoles
17/02"; break;
case 10: $dia= "Juves
18/02"; break;
case 11: $dia= "Viernes
19/02"; break;
case 12: $dia= "Sabado
20/02"; break;
case 13: $dia= "Domingo
21/02"; break;
case 14: $dia= "Lunes
22/02"; break;
case 15: $dia= "Martes
23/02"; break;
case 16: $dia= "Miercoles
24/02"; break;
case 17: $dia= "Juves
25/02"; break;
case 18: $dia= "Viernes
26/02"; break;
case 19: $dia= "Sabado
27/02"; break;
case 20: $dia= "Domingo
28/02"; break;
case 21: $dia= "Lunes
01/03"; break;
case 22: $dia= "Martes
02/03"; break;
case 23: $dia= "Miercoles
03/03"; break;
case 24: $dia= "Juves
04/03"; break;
case 25: $dia= "Viernes
05/03"; break;
case 26: $dia= "Sabado
06/03"; break;
case 27: $dia= "Domingo
07/03"; break;
case 28: $dia= "Lunes
08/03"; break;
case 29: $dia= "Martes
09/03"; break;
}
echo "
Dia: $num
$dia |
|
|
|
|
|
|
|
|
$acti |
";
$num++;
}// while DB
}// while 1 a 30
?>