Tengo que buscar una fecha con 3 cajas de texto (dia, mes, ano)
no me funciona....
control_filtro.php
Código PHP:
<?
$fecha = date("d-m-Y"); // fecha actual
$ano = date("Y"); // Año actual
$mes = date("m"); // Mes actual
$dia = date("d"); // Dia actual
$hoy=$ano.$mes.$dia;
if ( $dia == 'dia' )
$consulta = "SELECT * FROM am_inspeccion";
elseif ( $mes == 'mes' )
$consulta = "SELECT * FROM am_inspeccion";
elseif ( $ano == 'ano' )
$consulta = "SELECT * FROM am_inspeccion";
include "conexion.php";
$result=mysql_query ("SELECT * FROM am_inspeccion ORDER BY ins_folio desc");
echo"<h3 align=\"center\">Control por fecha </h3>";
echo "<form name=\"form1\" method=\"post\" action=\"control_filtro.php\">";
echo " <div align=\"center\">";
echo" <select name=\"dia\">
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
<option value=\"5\">5</option>
<option value=\"6\">6</option>
<option value=\"7\">7</option>
<option value=\"8\">8</option>
<option value=\"9\">9</option>
<option value=\"10\">10</option>
<option value=\"11\">11</option>
<option value=\"12\">12</option>
<option value=\"13\">13</option>
<option value=\"14\">14</option>
<option value=\"15\">15</option>
<option value=\"16\">16</option>
<option value=\"17\">17</option>
<option value=\"18\">18</option>
<option value=\"19\">19</option>
<option value=\"20\">20</option>
<option value=\"21\">21</option>
<option value=\"22\">22</option>
<option value=\"23\">23</option>
<option value=\"24\">24</option>
<option value=\"25\">25</option>
<option value=\"26\">26</option>
<option value=\"27\">27</option>
<option value=\"28\">28</option>
<option value=\"29\">29</option>
<option value=\"30\">30</option>
<option value=\"31\">31</option>
</select>
<select name=\"mes\">
<option value=\"01\">Enero</option>
<option value=\"02\">Febrero</option>
<option value=\"03\">Marzo</option>
<option value=\"04\">Abril</option>
<option value=\"05\">Mayo</option>
<option value=\"06\">Junio</option>
<option value=\"07\">Julio</option>
<option value=\"08\">Agosto</option>
<option value=\"09\">Septiembre</option>
<option value=\"10\">Octubre</option>
<option value=\"11\">Noviembre</option>
<option value=\"12\">Diciembre</option>
</select>
<select name=\"ano\">
<option value=\"2007\">2007</option>
<option value=\"2008\">2008</option>
<option value=\"2009\">2009</option>
<option value=\"2010\">2010</option>
<option value=\"2011\">2011</option>
<option value=\"2013\">2012</option>
<option value=\"2014\">2014</option>
<option value=\"2015\">2015</option>
<option value=\"2016\">2016</option>
<option value=\"2017\">2017</option>
<input type=\"submit\" name=\"Submit\" value=\"Filtrar\">
</div>
</select>
</form>
</h3>";
echo "<table border=0 width=90%><tr>";
echo "<tr>";
echo "<td></td><td></td><td>Folio</td><td>Fecha</td><td>Empresa</td><td>Ingresado por </td><td>Estado</td></td><td>Intentos</td></tr>
</tr>";
while($row=mysql_fetch_row($result)){
$row[1] = substr($row["1"],6,2)."/".substr($row["1"],4,2)."/".substr($row["1"],0,4);
switch($row[13]) {
case "Q": "Por Inspeccionar";
$row[13] = "Por Inspeccionar";
break;
case "A":
$row[13] = "Aprobada para inspeccionar";
break;
case "R":
$row[13] = "Rechazada para inspeccionar";
break;
case "T":
$row[13] ="Inspeccion terminada";
break;
case "I":
$row[13] ="Reinspecionar";
break;
case "E":
$row[13] ="Inspeccion rechazada";
break;
case "N":
$row[13] ="No disponible";
break;
case "L":
$row[13] ="Solicitud anulada";
break;
case "F":
$row[13] ="Rechazado por intentos fallidos";
break;
case "C":
$row[13] ="Proceso concevido";
break;
case "B":
$row[13] ="Inspección bloqueada";
break;
}
echo "<tr>
<td><td><a href=\"contratista.php?id_insmod=$row[0]\" target=\"parent\"><img src=\"am_modules/downloads/derec.gif\" width=16 height=16 alt=\"click\" border=0 align=left></a></td>
</td><td>$row[0]</td><td>$row[1]</td><td>$row[14]</td><td>$row[15]</td><td>$row[13]</td><td>$row[26] de 3</td> </tr>";
}
echo"</table>
";
?>
Muchas gracias