Código PHP:
<html>
<head>
<title>Seguimiento Credito</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/Textos.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function nueva_ventana(url, ancho, alto, barra) {
izquierda = (screen.width) ? (screen.width-ancho)/2 : 100
arriba = (screen.height) ? (screen.height-alto)/2 : 100
opciones = 'toolbar=0,location=1,directories=0,status=0,menubar=0,scrollbars=' + barra + ',resizable=0,,fullscreen=yes,width=' + ancho + ',height=' + alto + ',left=' + izquierda + ',top=' + arriba + ''
alert(url);
window.open(url, '', opciones)
}
</script>
</head>
<body>
<form name="form1" method="post" action="">
<table width="31%" border="1" align="center">
<tr>
<td bgcolor="#003300"><table width="56%" border="1" align="center">
<tr>
<td colspan="2"><div align="center"><font color="#FFFFFF" size="4" face="Verdana, Arial, Helvetica, sans-serif">Seguimiento
de Solicitudes</font></div></td>
</tr>
<tr>
<td width="25%"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif">Consecutivo</font></td>
<td width="75%"><font color="#FFFFFF">
<input name="txtConsecutivo" type="text" class="texto" id="txtConsecutivo" value="<?php echo $_REQUEST[txtConsecutivo];?>" size="10" maxlength="10" onFocus="this.style.background='#ffffcc'" onBlur="this.style.background='#ffffff'" onKeyPress="if(event.keyCode>=48 && event.keyCode<=57){} else{event.keyCode=8;}">
</font></td>
</tr>
<tr>
<td><div align="center">
<input name="Accion" type="hidden" id="Accion">
<input name="btnBuscar" type="button" id="btnBuscar" onClick="if(form1.txtConsecutivo.value!=''){form1.Accion.value='Buscar';submit();}"
style="border: #66FF66 1px solid; font-family: Verdana; font-size: 10px; width: 60; height: 20;background-color: #DEDEDE; font-weight: bold" value="Buscar">
</div></td>
<td><div align="center">
<input name="btnCerrar" type="button" id="btnCerrar" value="Cerrar" onClick="window.open('Contenido.php','_self');" style="border: #66FF66 1px solid; font-family: Verdana; font-size: 10px; width: 60; height: 20;background-color: #DEDEDE; font-weight: bold">
</div></td>
</tr>
<?php
if($_POST['Accion'] == 'Buscar')
{
include "ConexionRsnDes.php";
$Sql = "select count(*) as cont from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo'];
$Busq = ifx_query($Sql,$conexion);
$arr = ifx_fetch_row($Busq);
$Cont = $arr['cont'];
ifx_free_result($Cont);
if($Cont <=0)
{
echo "<tr>
<td colspan='2'><font color='#FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>No se encontraron datos de acuerdo a su criterio</font></td>
</tr>";
}
}
?>
</table></td>
</tr>
</table>
</form>
<?php
if($Cont>0)
{
?> <table width="80%" border="1">
<tr>
<td width="2%"> </td>
<td width="30%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Estado Credito</font></td>
<td width="22%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Fecha(D/M/A
hora) </font></td>
<td width="31%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Observaciones</font></td>
<td width="15%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Responsable</font></td>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">1</font></td>
<?php
include "ConexionRsnDes.php";
ifx_textasvarchar(1);
$Sql = "select * from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo']."
and segestado='In'";
$Busq = ifx_query($Sql,$conexion);
?>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">RECEPCION
SOLICITUD</font></td>
<?php
while($arr = ifx_fetch_row($Busq))
{
echo "<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segfecha']." ".$arr['seghora']."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".nl2br($arr['segobservacion'])."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segusuario']."</font></td>";
}
ifx_free_result($Busq);
?>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">2</font></td>
<?php
ifx_textasvarchar(1);
$Sql = "select * from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo']."
and segestado='ES'";
$Busq = ifx_query($Sql,$conexion);
?>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">ESTUDIO SOLICITUD</font></td>
<?php
while($arr = ifx_fetch_row($Busq))
{
echo "<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segfecha']." ".$arr['seghora']."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".nl2br($arr['segobservacion'])."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segusuario']."</font></td>";
}
ifx_free_result($Busq);
?>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">3</font></td>
<?php
ifx_textasvarchar(1);
$Sql = "select * from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo']."
and segestado='AS'";
$Busq = ifx_query($Sql,$conexion);
?>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">APROBACION
SOLICITUD</font></td>
<?php
while($arr = ifx_fetch_row($Busq))
{
echo "<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segfecha']." ".$arr['seghora']."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".nl2br($arr['segobservacion'])."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segusuario']."</font></td>";
}
ifx_free_result($Busq);
?>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">4</font></td>
<?php
ifx_textasvarchar(1);
$Sql = "select * from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo']."
and segestado='LG'";
$Busq = ifx_query($Sql,$conexion);
?>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">LEGALIZACION
DE GARANTIAS</font></td>
<?php
while($arr = ifx_fetch_row($Busq))
{
echo "<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segfecha']." ".$arr['seghora']."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".nl2br($arr['segobservacion'])."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segusuario']."</font></td>";
}
ifx_free_result($Busq);
?>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">5</font></td>
<?php
ifx_textasvarchar(1);
$Sql = "select * from segsolcredito where segconsecsol=".$_REQUEST['txtConsecutivo']."
and segestado='OG'";
$Busq = ifx_query($Sql,$conexion);
?>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">FIRMA/ ORDEN
GIRO/ ENTREGA SERVICIO</font></td>
<?php
while($arr = ifx_fetch_row($Busq))
{
echo "<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segfecha']." ".$arr['seghora']."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".nl2br($arr['segobservacion'])."</font></td>
<td><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>".$arr['segusuario']."</font></td>";
}
ifx_free_result($Busq);
?>
</tr>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">6</font></td>