<?php
include("conectarequipo.php");
$mes = $_POST['mes'];

echo $mes.'<br>';

$nyear = date("Y");


$consulta = "select * from $mes where YEAR(fecha_ini)='".$nyear."'";

echo $consulta;

echo '
    <br>
    <table border="1" align="center" width="90%" bgcolor="#000000">
        <FORM ACTION="modificar.php" METHOD="POST">
        <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%">
        ';

            $resultado = mysql_query($consulta, $conexion);

            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%'><input size='8' type='text' name='tur_1' value=".$res['tur_1']."></td>
            <td align='center' width='11%'><input size='8' type='text' name='tur_1' value=".$res['eq_1']."></td>
            <td align='center' width='11%'><input size='8' type='text' name='tur_1' value=".$res['eq_2']."></td>
            <td align='center' width='12%'><input size='9' type='text' name='tur_1' value=".$res['te_1']."></td>
            <td align='center' width='12%'><input size='9' type='text' name='tur_1' value=".$res['te_2']."></td>
            <td align='center' width='12%'><input size='9' type='text' name='tur_1' value=".$res['te_3']."></td>
            <td align='center' width='12%'><input size='9' type='text' name='tur_1' value=".$res['te_4']."></td>
            <input type='hidden' name='mes' value='enero'>
            </tr>";
            }


    echo "
        </table>
        <FORM CLASS='borde' ACTION='../modificar.php?mes=1' METHOD='GET'>
        <INPUT TYPE='SUBMIT' NAME='Guardar' VALUE='Guardar'>
        <br>
    ";
?>