Tengo un serio problema, con 2 cajas de texto me funciona, pero necesito que sea en 3 (dia, mes, año). Modifique la consulta que creo que ahi esta el problema pero nada, haber si alguien me puede ayudar por favor
Código PHP:
<?php
$index_page = false;
$theme_data = "";
//---> include idioma
//
$config["leng"] = "sp"; // Español
include_once( "am_modules/inspec/idioma/msg_".check_lang($config["leng"]).".php" );
$page_name = lg_Titulo;
srand((double)microtime()*1000000);
$filename = "am_modules/downloads/style.css";
$fp = fopen( $filename, "r" );
$headcode = "<style type=\"text/css\">".fread( $fp, filesize($filename) )."</style>";
fclose($fp);
draw_header();
if( ! $session["logged"] )
{
theme_draw_box( INGRESO_TITLE, INGRESO_ACTIVATE_ERROR, "100%" );
draw_footer();
exit;
}
//$f_fecing1 = substr($row["ins_fecing1"],6,2)."/".substr($row["ins_fecing1"],4,2)."/".substr($row["ins_fecing1"],0,4);
$error = "";
$ok = false;
theme_draw_box_open( lg_TitCon, "100%" );
?>
<style type="text/css">
TD {
font-size : 10px;
font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
}
</style>
<?
if ( isset( $_POST[ 'buscar' ] ) && isset( $_POST[ 'ano' ] )&& isset( $_POST[ 'mes' ] )&& isset( $_POST[ 'dia' ] ) && isset( $_POST[ 'palabra' ] ) )
{
include_once ("conexion.php");
//aca creo que esta el problema
if( !empty( $_POST['buscar'] ) ) {
$mes = addslashes($_POST['ano']);
$consulta = "SELECT * FROM am_inspeccion WHERE ano='$ano'";
} else
if( !empty( $_POST['buscar'] ) ) {
$mes = addslashes($_POST['mes']);
$consulta = "SELECT * FROM am_inspeccion WHERE mes='$mes'";
} else
if( !empty( $_POST['buscar'] ) ) {
$mes = addslashes($_POST['dia']);
$consulta = "SELECT * FROM am_inspeccion WHERE dia='$dia'";
}
//fin problema
$query_Rs = mysql_query($consulta) or die(mysql_error());
$accion="control_datos_filtro.php?";
echo "<table width=100%>";
//echo "<td><b> </b></td><td><b>Folio</b></td><td><b>Mes</b></td><td><b>Para</b></td><td><b>De</b></td>";
while ( $row= mysql_fetch_array( $query_Rs ) )
{
echo"<table width=587>
<tr>
<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>";
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>
";
}
else
{
?>
<style type="text/css">
TD {
font-size : 10px;
font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
}
</style>
<?
echo"</p>";
echo "</div> ";
echo "<form name=\"form1\" method=\"post\" action=\"$accion\">";
echo " <h3 align=\"center\"> <span class=\"Estilo2\"></span><br>";
echo " </h3>";
echo " <pre> ";
echo "</pre>";
echo " <div align=\"center\">";
echo " <pre>";
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>";
echo " <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>";
echo " <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>
</div>
</select>";
echo "<input name=\"buscar\" type=\"submit\" value=\"Buscar\"> ";
echo " </pre>";
echo " </div>";
echo " <pre> </pre>";
echo "</form>";
?>
<?php
}
?>