Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("conectarequipo.php");
- $nyear = date("Y");
- $consulta = "select * from enero where MONTH(fecha_ini)=01 and YEAR(fecha_ini)='".$nyear."'";
- $resultado = mysql_query($consulta, $conexion);
- if(mysql_num_rows($resultado)!=0){
- echo '
- <br>
- <h2 align="center"> Enero </2>
- <table border="1" align="center" width="90%" bgcolor="#000000">
- <tr>
- <td align="center" width="22%"><font color="#ffffff">FECHA</font></td>
- <td align="center" width="10%"><font color="#ffffff">TURNO</font></td>
- <td align="center" width="22%"><font color="#ffffff">EQUIPO</font></td>
- <td align="center" width="60%"><font color="#ffffff">TERRENO</font></td>
- </tr>
- </table>
- <table border="1" align="center" width="90%">
- ';
- while($res=(mysql_fetch_array($resultado))){
- echo "
- <tr>
- <td align='center' width='11%'>".$res['fecha_ini']."</td>
- <td align='center' width='11%'>".$res['fecha_fin']."</td>
- <td align='center' width='10%'>".$res['tur_1']."</td>
- <td align='center' width='11%'>".$res['eq_1']."</td>
- <td align='center' width='11%'>".$res['eq_2']."</td>
- <td align='center' width='12%'>".$res['te_1']."</td>
- <td align='center' width='12%'>".$res['te_2']."</td>
- <td align='center' width='12%'>".$res['te_3']."</td>
- <td align='center' width='12%'>".$res['te_4']."</td>
- </tr>";
- }
- echo "
- </table>
- <FORM ACTION='modificar.php' METHOD='GET'>
- <input type='hidden' name='id' value='enero'>
- <INPUT TYPE='SUBMIT' VALUE='Modificar'>
- <br>
- ";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement