I have a problem with this code. I see other questions on this, but continued without find the mistake. This code work in other computer, but now is giving me problems in my computer. Here is my code, i hope than help me....
<?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; }?> <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>
Thank you for you help...