<?php include "conexion.php";
$fecha = date('Y-m-j');
$ayer = strtotime ( '-1 day' , strtotime ( $fecha ) ) ;
$ayer = date ( 'Y-m-j' , $ayer );
$hacedias = strtotime ( '-8 day' , strtotime ( $fecha ) ) ;
$hacedias = date ( 'Y-m-j' , $hacedias );
$consulta = "SELECT date_format(fecha,'%d %M') AS FECHA, round((SUM(`TotalMinutos`)/60),1) FROM reporte WHERE ingeniero ='". $_SESSION['id']."' AND fecha BETWEEN '$hacedias' AND '$ayer' GROUP BY fecha";
$rs = mysql_query($consulta,$conexion);
if(mysql_num_rows($rs)!=0)
{
?>
<p></p>
<p></p>
<table border="0" cellpadding="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100">
<tr>
<?PHP
$i = 0;
while ($reg=mysql_fetch_array($rs)){
if($i == 8){
echo "</tr><tr>";
$i = 0;
} else {}
?>
<td width="100">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="150">
<tr>
<td width="80"><B><?=$reg['FECHA']?></B></td>
</tr>
<tr>
<td width="80"><?=$reg['round((SUM(`TotalMinutos`)/60),1)']?> Horas</td>
</tr>
</table>
</td>
<?
$i++;
?>
</tr>
</table>
<p>
<?PHP
} else { echo "<h3><p style='color:#FF0000'> ATENCION!!! <br> No has registrado tus tiempos en los ultimos 5 dias.</p></h3>"; }
?>
</table>
- Output for 5.4.0 - 5.4.27
- Parse error: syntax error, unexpected 'else' (T_ELSE) in /in/fd27T on line 47
Process exited with code 255. - Output for 5.3.0 - 5.3.28
- Parse error: syntax error, unexpected T_ELSE in /in/fd27T on line 47
Process exited with code 255.
preferences:
187.54 ms | 1395 KiB | 64 Q