Hola mi pregunta creo que no es muy dificil de responder, perola verdad no se, jeje, debe de ser el estres.
necesito hacer una busqueda que al consultar me de los resultados en otro archivo. Ej: consulto.php - resultados.php
les dejo mi codigo, me hace la busqueda, pero la necesito a pasar a un arhivo diferente.
Código PHP:
<td colspan="7"><hr>
<strong>Estado: Tabla Inspecciones</strong>
<hr></td>
</tr>
<tr>
<td> </td>
<td><div align="center"><strong>Folio</strong></div></td>
<td><div align="center">
<p><strong>Fecha Ingreso</strong></p>
</div></td>
<td><div align="center"><strong>Equipo a Inspeccionar</strong></div></td>
<td><div align="center"><strong>Estado</strong></div></td>
<td><div align="center"><strong>Intentos</strong></div></td>
</tr>
<?php
$palabra1 = $_POST['folio'];
$palabra2 = $_POST['fecha'];
$palabra3 = $_POST['estado'];
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
if( !empty( $_POST['folio'] ) ) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra1."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if (( !empty( $_POST['folio'] ) ) or ( !empty( $_POST['fecha'] ) )) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra1."%') and (ins_fecing like '%".$palabra2."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if ( !empty( $_POST['fecha'] ) ) {
$campo="ins_fecing";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra2."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if ( !empty( $_POST['estado'] ) ) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_estado like '%".$palabra3."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if (( !empty( $_POST['estado'] ) ) or ( !empty( $_POST['folio'] ) )) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra3."%') and (ins_fecing like '%".$palabra1."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if (( !empty( $_POST['estado'] ) ) or ( !empty( $_POST['folio'] ) ) or ( !empty( $_POST['fecha'] ) )) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra3."%') and (ins_fecing like '%".$palabra1."%') and (ins_fecing like '%".$palabra2."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}else{
if (( !empty( $_POST['estado'] ) ) or ( !empty( $_POST['fecha'] ))) {
$campo="ins_folio";
if ( $campo == 'ins_folio' )
$consulta = "SELECT * FROM (am_inspeccion,am_rl_equins) where ins_folio=rei_folio and (ins_digito = '".$session["name"]."') and (ins_folio like '%".$palabra3."%') and (ins_fecing like '%".$palabra2."%') and (ins_proyecto like '$f_proyecto') ORDER BY ins_folio DESC";
}
}
}
}
}
}
}
$query_Rs = mysql_query($consulta) or die(mysql_error());
echo "<hr>";
while ( $row= mysql_fetch_array( $query_Rs ) )
{
echo " <tr>";
echo " <td><a href=\"contratista.php?id_insmodd=$row[0]\" target=\"_top\"><img src=\"am_modules/downloads/derec.gif\" width=16 height=16 alt=\"click\" border=0 align=left></a></td>";
echo " <td><div align=\"center\">$row[0]</a></div></td>";
echo " <td><div align=\"center\">$row[1]</a></div></td>";
echo " <td><div align=\"center\">$row[33]</a></div></td>";
echo " <td><div align=\"center\">$row[13]</a></div></td>";
echo " <td><div align=\"center\">$row[26] de 3</a></div></td>";
echo " </tr>";
}
?>
<tr>
<td colspan="7"> </td>
</tr>