MOON
Server: Apache/2.2.34 (Unix) mod_ssl/2.2.34 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 FrontPage/5.0.2.2635
System: Linux server.asjudinet.com 2.6.32-042stab141.3 #1 SMP Fri Nov 15 22:45:34 MSK 2019 i686
User: asjudine (504)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: /home/asjudine/www/ingresar_creditos_hr.php
<?php
require_once("mainfile.php");
include ("config.php");
global $dbi;

$interes2=0.03;
$interes=0.04;
$temp1=0;
$temp2=0;
$num_dias=0;
$cap_end=0;
$salario_min=433800;
$vmt=0;

function Conectarse()
	{
	   if (!($link=@mysql_connect("localhost","asjudine","as2006")))
	   {
		  echo "Error conectando con el servidor.";
		  exit();
	   }
	   $dbname = "asjudinet";
	   if (!@mysql_select_db($dbname,$link))
	   {
		  echo "Error seleccionando la base de datos.";
		  exit();
	   }
	   return $link;
	}
	Conectarse();


if(isset($_POST["consultar"]))
{
/*		$sqlnom2 = "select cedula, grado, nombre, devengado, descuento, neto, unidad from datos_credito where cedula = '$cedula2'";
     	$control2 = mysql_query($sqlnom2, $dbi) or die(mysql_error());	*/
$resul = mysql_query('SELECT cedula, grado, nombre, devengado, descuento, neto, unidad FROM datos_credito WHERE cedula =  "' . $_POST["cedula2"]  . '" ');
			if (!$resul) {
				die('Invalid query: ' . mysql_error());
			}
    	list($cod, $gra, $ape, $deven, $desc, $sala, $uni ) = mysql_fetch_row($resul);
		
		
}
if(isset($_POST["guardar"]))
{	
        	if($cedula!='')
			{
			
//			$mssql9 = mysql_query("select * from creditos where cedula = '$cedula'",$dbi);
			$resule = mysql_query('SELECT * FROM creditos WHERE cedula =  "' . $_POST["cedula"]  . '" and estado = "1" ');
			if (!$resule) {
				die('Invalid query: ' . mysql_error());
			}
	    	$num=mysql_num_rows($resule); 
			if($num==0)
			{
			
		  	//calcula mes termino y año termino
  				$mt = floor(($mi + $num_cuotas)/12);
				$submt = (($mi + $num_cuotas)%12)-1;
				$at = $mt + $ai;
				if($submt==0)
				{
					$submt = 12;
					$at = $at-1;
				}
				if($submt=='-1')
				{
					$submt = 11;
					$at = $at-1;
				}
				
			if($intd==''&&$fecha_inicio!='0000-00-00'&&$val_neto=='')
			{
			//calcular el numero de dias
			
			$sql8 ="SELECT DATEDIFF('$fecha','$fecha_inicio') dias"; 
			$resulte=mysql_query($sql8);  
			$num2=mysql_num_rows($resulte);  
			$data = mysql_fetch_array($resulte);
			$num_dias = abs($data['dias']); 

		
		
			//operaciones para hallar valor neto a consignar
			
			$temp2 = (($monto_sol*$interes2)/30);//interes deducible
		    $val_neto = ($monto_sol-($temp2*$num_dias));
			
			//hallar el interes deducible
			
			$intd = $temp2*$num_dias;
			}
			
			 //guarda procesos
	        
mysql_query("INSERT INTO creditos(ciudad, fecha, nombres, cedula, codigo, grado,  direccion_envio, ciudad_envio, telefono, celular, email, monto_solicitado, salario, numero_cuotas, valor_mensual, cuenta_ahorros, banco_cuenta, neto_consignar , interes_deducible, inicio_pagos, numero_libranza, tipo_credito, mes_inicio, ano_inicio, mes_termino, ano_termino, empresa, proveedor, estado) VALUES ('" . $_POST["ciudad"]  . "','" . $_POST["fecha"]  . "','" . $_POST["apellidos"]  . "','" . $_POST["cedula"]  . "','" . $_POST["codigo"]  . "','" . $_POST["grado"]  . "','" . $_POST["direccion_envio"]  . "','" . $_POST["ciudad_envio"]  . "','" . $_POST["telefono"]  . "','" . $_POST["celular"]  . "','" . $_POST["email"]  . "','" . $_POST["monto_sol"]  . "','" . $_POST["salario"]  . "','" . $_POST["num_cuotas"]  . "','" . $_POST["val_mensual"]  . "','" . $_POST["cuenta_aho"]  . "','" . $_POST["banco_cuenta"]  . "','" . $_POST["val_neto"]  . "','" . $_POST["intd"]  . "','" . $_POST["fecha_inicio"]  . "','" . $_POST["numero_libranza"]  . "','H','" . $_POST["mi"]  . "','" . $_POST["ai"]  . "','" . $_POST["submt"]  . "','" . $_POST["at"]  . "','" . $_POST["emp"]  . "','" . $_POST["proved"]  . "')"); 
				        

			
				//$sqlnom6 = "select cod_desc from empresas where codigo = '$emp'";
     			//$control6 = mysql_query($sqlnom6, $dbi) or die(mysql_error());
				$resut6 = mysql_query('SELECT cod_desc FROM entidad_laboral WHERE codigo = "' . $_POST["emp"] . '" ');
			if (!$resut6) {
				die('Invalid query: ' . mysql_error());
			}	 
    			list($codemp) = mysql_fetch_row($resut6);
						
 mysql_query("INSERT INTO reporte_mindefensa(codigo, nombre, grado, cod_desc, libranza, fecha_libranza, tipo_doc, valor_descuento, cuotas, pagaduria, mes_inicio, ano_inicio, mes_termino, ano_termino, proveedor) VALUES ('" . $_POST["codigo"]  . "','" . $_POST["apellidos"]  . "','" . $_POST["grado"]  . "','" . $_POST["codemp"]  . "','" . $_POST["numero_libranza"]  . "','" . $_POST["fecha"]  . "','LIB','" . $_POST["val_mensual"]  . "','" . $_POST["num_cuotas"]  . "','" . $_POST["emp"]  . "','" . $_POST["mi"]  . "','" . $_POST["ai"]  . "','" . $_POST["submt"]  . "','" . $_POST["at"]  . "','H ROSERO')"); 

            
            echo "<script>alert('Los datos fueron grabados correctamente');</script>";	  
	  
/*		 $sqlnom3 = "select ciudad, nombres, cedula, codigo, grado, direccion_envio, ciudad_envio, telefono, celular, email, monto_solicitado, salario, valor_mensual, cuenta_ahorros, banco_cuenta, neto_consignar, inicio_pagos, interes_deducible, numero_libranza from creditos where cedula = '$cedula'";
		 $control3 = mysql_query($sqlnom3, $dbi) or die(mysql_error());	*/
		 
		 $resule = mysql_query('SELECT ciudad, nombres, cedula, codigo, grado, direccion_envio, ciudad_envio, telefono, celular, email, monto_solicitado, salario, valor_mensual, cuenta_ahorros, banco_cuenta, neto_consignar, inicio_pagos, interes_deducible, numero_libranza FROM creditos WHERE cedula =  "' . $_POST["cedula"]  . '" ');
			if (!$resule) {
				die('Invalid query: ' . mysql_error());
			} 
		 list($ciu,  $ape, $cc, $cod, $gra, $dir, $ciu, $tel, $cel, $em, $mon, $sala, $valmen, $cuent,$banc, $consig, $inicio_pag , $ided, $num_lib) = mysql_fetch_row($resule);
		 
		 
		// $sqlnom5 = "select devengado, descuento, neto, unidad from datos_credito where cedula = '$codigo'";
     	//$control5 = mysql_query($sqlnom5, $dbi) or die(mysql_error());
		 $resur = mysql_query('SELECT devengado, descuento, neto, unidad FROM datos_credito WHERE cedula =  "' . $_POST["codigo"]  . '" ');
			if (!$resur) {
				die('Invalid query: ' . mysql_error());
			} 	 
    	list($deven, $desc, $sala, $uni ) = mysql_fetch_row($resur);
		
		}else{
				
				echo "<script>alert('Tiene un credito vigente');</script>";
			 }	
	}else{
			echo "<script>alert('Debe ingresar numero de cedula, para continuar');</script>";
	}
}


//$query_sql = "SELECT * FROM empresas order by nombre";
//$sql = mysql_query($query_sql, $dbi) or die(mysql_error());
 $sql = mysql_query('SELECT * FROM entidad_laboral order by nombre ');
			if (!$sql) {
				die('Invalid query: ' . mysql_error());
			}
$row_sql = mysql_fetch_assoc($sql);
$totalRows_sql = mysql_num_rows($sql);  		

?>
<html>
<head>
<title>INGRESAR CREDITOS</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<style type="text/css">
<!--
.titulos {font: 16px; color: red; font-family:Arial; font-weight:bold}
.boton {  background-color: #FFCCCC; color:#FFFFFF; width:150px; border: 4px solid #0000CC; font-family:Arial; color:#990000;}
.texto {background-color: #CCFFCC; font-size: 13px; font-family: Arial; color:#0000CC; display: block;}
.fecha {background-color: #CCFFCC; font-size: 12px; font-family: Arial; color: #000099; width:10px display: block;}
.campo {background-color: #FFFFCC; border:1px solid #990000; font-family:Arial;  font-size:11px; height: inherit}
.lista { background-color:#99FFFF; font-family: Arial; font-size: 11px;	color: #990000;}
.label {background-color: #00CCFF ; font-size: 14px; font-family: Arial; color:#0000CC; display: block;}
.area {background-color: #CCFFCC; font-size: 13px; width:40px font-family: Arial; color:#0000CC; display: block;}
.variables {background-color: #CCFFCC; font-size: 12px; font-family: Arial; color: #003333 ; width:10px display: block; border: 2px solid #006633;}
.sel { background-color:#DDFFFF; width:400px; border: 1px solid #0099FF; font-family:Arial; font-style:italic; color:#990000 }
.sel2{ background-color:#DDFFFF; border: 1px solid #0099FF; font-family:Arial; font-style:italic; font-weight:bold; color:#990000 }
.seleccion { background-color: #CCFFCC; width:340px; border: 1px solid #0099FF; font-family:Arial; color:#990000;}
.boton2 {font-family: Verdana; font-size: 8 pt; color: #000080; background-color: #C0C0C0; border-style: solid; }
.letras {background-color: #99CCFF; font-size: 10px; font-family: Arial; color:#0000CC; display: block;}
.campo2 {background-color: #99CCCC; border:1px solid #0066FF; font-family:Arial; font-size:10px; height: inherit}
.sel3{ background-color:#DDFFFF; font-family:Arial; font-size:10px; color: #000066 }
body {
	background-image: url(fondo_argollado.gif);
}
.Estilo11 {
	font-size: 16px;
	font-weight: bold;
	color: #3333FF;
}
.Estilo12 {font-size: 24px}
.Estilo14 {background-color: #CCFFCC; font-size: 13px; font-family: Arial; color: #0000CC; display: block; font-weight: bold; }
.Estilo50 {color: #CC3333;
	font-family: "Arial Narrow";
	font-weight: bold;
}
.campo1 {background-color:#FFFFAA; width: 100px; border:2px solid #990000;}
.Estilo2 {
	font-family: Arial;
	font-size: 16px;
	color: #990000;
	font-weight: bold;
	font-style: italic;
}
.boton1 {background-color: #FFCCCC; color:#FFFFFF; width:90px; height:25; border: 3px solid #0000CC; font-family:Arial; color:#990000;}
-->
</style>
<script languaje="JavaScript">
function Mostrar_Fecha()
{
         var mydate=new Date()
         var year=mydate.getYear()
         if (year < 1000)
                 year+=1900
                 var day=mydate.getDay()
                 var month=mydate.getMonth()
                 var daym=mydate.getDate()
                 if (daym<10)
                    daym="0"+daym
                    var dayarray=new Array("Domingo","Lunes","Martes","Miercoles","Jueves","Viernes","Sabado")
                    var montharray=new Array("Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre")
                    document.write("<b><font face='Arial, Helvetica, sans-serif'>"+dayarray[day]+" "+daym+" de "+montharray[month]+" de "+year+"</font></b>")
}					
</script>
<script Language="JavaScript">
<!--
function validar()
{

  if (formulario.folio2.value == "")
  {
    alert("Falta ingresar el Folio2");
    formulario.folio2.focus();
    return (false);
  }   

	if(formulario.folio2.value < pf)
	{	 
     	   alert('El folio2 no debe ser menor que el folio1');
           formulario.folio2.focus();
           return (false);	
	}	

  if (formulario.actuacion.value == "")
  {
    alert("Falta ingresar la actuación");
    formulario.actuacion.focus();
    return (false);
  }

  if (formulario.codigo_funcionario.value == "")
  {
    alert("Falta seleccionar el nombre del funcionario");
    formulario.codigo_funcionario.focus();
    return (false);
  }

return (true);
}
//--></script>

<SCRIPT LANGUAGE='JavaScript'>
var default1 = "INGRESO DE CREDITOS"; // only shown once at page load
var text1 = "El primer encabezado muestra en detalle los datos del proceso seleccionado";
var text2 = "la segunda parte muestra el formulario para el ingreso de revistas";
var text3 = "No se le olvide tener en cuenta el número del folio que se entrega en el juzgado";
var changeRate = 3000; // 1000 = 1 second
var messageNumber = 0;

function changeStatus()
{
  if (messageNumber == 0) {
     window.status=default1;
     document.title=default1;
    }
  else if (messageNumber == 1) {
     window.status=text1;
    }
  else if (messageNumber == 2) {
     window.status=text2;
     }
  else if (messageNumber == 3) {
     window.status=text3;
     messageNumber = 0;
     }
  messageNumber++;
  setTimeout("changeStatus();",changeRate);
}
changeStatus(); // leave here to run right away
// -->
</SCRIPT>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="document.formulario.folio1.focus()">
<form name="formulario" action="" method="post" onSubmit="return validar(this)">
<table width="752" height="398" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr bgcolor="#FFFFCC">
    <td width="666" class="titulos"><div align="center" class="Estilo12"><img src="ELEMENTOS/cabezote_servi_2.jpg" width="772" height="103"></div></td>
  </tr>
  <tr bgcolor="#FFFFCC">
    <td width="666" class="titulos"><div align="center" class="Estilo12">INGRESO CREDITOS H. ROSERO </div></td>
  </tr><tr bgcolor="#ECE9D8">
    <td height="8" class="fecha"><div align="center">
      <p>
        <script languaje="JavaScript">Mostrar_Fecha()</script>
        <span class="Estilo11">SOLICITUD DE CREDITO </span></p>
      <p><span class="Estilo2">C&eacute;dula o Codigo:</span>
        <input name="cedula2" type="text" class="campo1" id="cedula2" value="" size="15" maxlength="15">
      </p>
      <p>
        <input name="consultar" id="consultar" type="submit" class="boton1" value="Consultar">
      </p>
    </div></td>
  </tr>
  
  <tr bgcolor="#FFCC99">
    <td height="260" bgcolor="#FFFFFF"><fieldset>
   <legend><span class="Estilo14">Datos del cliente:</span></legend>
   <table width="744" height="219" border="0" align="center" cellpadding="0" cellspacing="1">
     <tr bgcolor="#FFFFFF">
       <td width="147"><div align="center"><span class="label">Sucursal:</span></div></td>
       <td><label>
         <select name="ciudad" id="ciudad">
           <option value="VENTAS 1" selected>VENTAS 1</option>
           <option value="CAN">CAN</option>
           <option value="BOGOTA">BOGOTA</option>
           <option value="MEDELLIN">MEDELLIN</option>
           <option value="CALI">CALI</option>
           <option value="PEREIRA">PEREIRA</option>
           <option value="MANIZALES">MANIZALES</option>
           <option value="IBAGUE">IBAGUE</option>
           <option value="BARRANQUILLA">BARRANQUILLA</option>
           <option value="NEIVA">NEIVA</option>
           <option value="BUCARAMANGA">BUCARAMANGA</option>
           <option value="PASTO">PASTO</option>
           <option value="FLORENCIA">FLORENCIA</option>
           <option value="VILLAVICENCIO">VILLAVICENCIO</option>
           <option value="MONTERIA">MONTERIA</option>
           <option value="VALLEDUPAR">VALLEDUPAR</option>
           <option value="HONDA">HONDA</option>
           <option value="TUNJA">TUNJA</option>
           <option value="MOCOA">MOCOA</option>
           <option value="H ROSERO">H ROSERO</option>
         </select>
       </label></td>
       <td width="95"><div align="center"><span class="label">Fecha:</span></div></td>
       <td width="230"><input name="fecha" type="text" class="campo" id="fecha" value="<?php echo date ( "Y-n-j" ) ?>" size="15" maxlength="10" readonly=""> </td>
       </tr>
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">Apellidos y Nombres:</span></div></td>
       <td colspan="3"><input name="apellidos" type="text" class="campo" id="apellidos" value="<?php echo $ape ?>" size="50" maxlength="50" > </td>
	   </tr>
	   
	   
	   	   
	   
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">C.C No :</span></div></td>
       <td><input name="cedula" type="text" class="campo" id="cedula" value="<?php echo $cc ?>" size="25" maxlength="25"></td>
       <td><div align="center"><span class="label">Codigo:</span></div></td>
       <td><input name="codigo" type="text" class="campo" id="codigo" value="<?php echo $cod ?>" size="25" maxlength="25"></td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">Grado:</span></div></td>
       <td><input name="grado" type="text" class="campo" id="grado" value="<?php echo $gra ?>" size="35" maxlength="35"></td>
	   <td><div align="center"></div></td>
       <td colspan="3">&nbsp;</td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">Direccion  envio de documentos  :</span></div></td>
       <td><input name="direccion_envio" type="text" class="campo" id="despacho_judicial4" value="<?php echo $dir ?>" size="50" maxlength="60"></td>
       <td><div align="center"><span class="label">Ciudad:</span></div></td>
       <td><input name="ciudad_envio" type="text" class="campo" id="ciudad_envio" value="<?php echo $ciu ?>" size="35" maxlength="35" ></td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">Telefono:</span></div></td>
       <td><input name="telefono" type="text" class="campo" id="telefono" value="<?php echo $tel ?>" size="35" maxlength="35"></td>
       <td><div align="center"><span class="label">Celular:</span></div></td>
       <td><input name="celular" type="text" class="campo" id="celular" value="<?php echo $cel ?>" size="35" maxlength="35"></td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td><div align="center"><span class="label">Email:</span></div></td>
       <td><input name="email" type="text" class="campo" id="email" value="<?php echo $em ?>" size="35" maxlength="35"></td>
       <td><div align="center"><span class="label">Unidad:</span></div></td>
       <td><input name="unidad" type="text" class="campo" id="unidad" value="<?php echo $uni ?>" size="50" maxlength="50" readonly=""></td>
     </tr>
   </table> 
   </fieldset></td>
   <table width="879" height="219" border="0" align="center" cellpadding="2" cellspacing="2">
  
  
  <tr bgcolor="#FFCC99">
    <td width="871" height="215" bgcolor="#FFFFFF"><fieldset>
   <legend><span class="Estilo14">Datos del credito:</span></legend>
   <table width="869" height="228" border="0" align="center" cellpadding="0" cellspacing="1">
     <tr bgcolor="#FFFFFF">
       <td width="157" height="28"><div align="center"><span class="label">Monto Solicitado $ :</span></div></td>
       <td colspan="3"><input name="monto_sol" type="text" class="campo" id="monto_sol" value="<?php echo $mon ?>" size="35" maxlength="35" ></td>
       <td colspan="2"><div align="center"><span class="label">Total Devengado   $:</span></div></td>
       <td colspan="3"><input name="devengado" type="text" class="campo" id="devengado" value="<?php echo $deven ?>" size="35" maxlength="35" readonly=""></td>
       </tr>
     <tr bgcolor="#FFFFFF">
       <td height="23"><div align="center"><span class="label">Numero de Cuotas :</span></div></td>
       <td colspan="3"><select name="num_cuotas" id="num_cuotas">
         <option value="6" selected>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>
         <option value="32">32</option>
       </select> 
       -        <input name="fec_ini2" type="text" class="campo2" id="fec_ini2" value="<?php echo $num_cuotas ?>" size="15" maxlength="10"  readonly=""></td>
	   <td colspan="2"><div align="center"><span class="label">Total Descuento $:</span></div></td>
	   <td colspan="3"><input name="descuento" type="text" class="campo" id="descuento" value="<?php echo $desc ?>" size="35" maxlength="35" readonly=""></td>
     </tr>
	   
     <tr bgcolor="#FFFFFF">
       <td height="29"><div align="center"><span class="label">Valor Mensual $ :</span></div></td>
       <td colspan="3"><input name="val_mensual" type="text" class="campo" id="val_mensual" value="<?php echo $valmen ?>" size="35" maxlength="35" ></td>
       <td colspan="2"><div align="center"><span class="label">Salario Neto  $:</span></div></td>
       <td colspan="3"><input name="salario" type="text" class="campo" id="salario" value="<?php echo $sala ?>" size="35" maxlength="35" readonly=""></td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td height="29"><div align="center"><span class="label">Neto a Consignar  $   :</span></div></td>
       <td colspan="3"><input name="val_neto" type="text" class="campo" id="val_neto" value="<?php echo $consig ?>" size="35" maxlength="35" ></td>
       <td colspan="2"><div align="center"><span class="label">Cuenta ahorros No :</span></div></td>
       <td colspan="3"><input name="cuenta_aho" type="text" class="campo" id="cuenta_aho" value="<?php echo $cuent ?>" size="35" maxlength="35"></td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td height="29"><div align="center"><span class="label">Primer Descuento   $  :</span></div></td>
       <td colspan="3"><input name="fecha_inicio" type="text" class="campo" id="fecha_inicio" value="0000-00-00" size="13" maxlength="10" > 
         - 
           <input name="fec_ini" type="text" class="campo2" id="fec_ini" value="<?php echo $inicio_pag ?>" size="15" maxlength="10"  readonly=""></td>
       <td colspan="2"><div align="center"><span class="label">Banco :</span></div></td>
       <td colspan="3"><input name="banco_cuenta" type="text" class="campo" id="banco_cuenta" value="<?php echo $banc ?>" size="35" maxlength="35" ></td>
     </tr>
     
     <tr bgcolor="#FFFFFF">
       <td height="27"><div align="center"><span class="label">Dias Pendientes   :</span></div></td>
       <td colspan="3"><input name="diasno" type="text" class="campo2" id="diasno" value="<?php echo $num_dias ?>" size="20" maxlength="15" readonly=""></td>
       <td colspan="2"><div align="center"><span class="label">Empresa :</span></div></td>
       <td colspan="3"><select name="emp" id="emp">
         <option value="">--SELECCIONE LA EMPRESA--</option>
         <?php
     do {  
?>
         <option value="<?php echo $row_sql['codigo'];?>"><?php echo $row_sql['nombre']?></option>
         <?php
} while ($row_sql = mysql_fetch_assoc($sql));
  $rows = mysql_num_rows($sql);
  if($rows > 0) {
      mysql_data_seek($sql, 0);
       $row_sql = mysql_fetch_assoc($sql);
  }
?>
       </select></td>
     </tr>
     
     <tr bgcolor="#FFFFFF">
       <td height="27"><div align="center"><span class="label">Interes Deducible   $   :</span></div></td>
       <td colspan="3"><input name="intd" type="text" class="campo" id="intd" value="<?php echo $ided ?>" size="35" maxlength="35" ></td>
       <td height="27" colspan="2"><div align="center"><span class="label">Proveedor    :</span></div></td>
       <td colspan="2"><strong>
         <select name="proved" id="proved">
           <option value="H. ROSERO">H. ROSERO</option>
         </select>
       </strong></td>
       <td width="98">&nbsp;</td>
     </tr>
     <tr bgcolor="#FFFFFF">
       <td height="27"><div align="center"><span class="label">Numero Libranza    :</span></div></td>
       <td colspan="3"><input name="numero_libranza" type="text" class="campo" id="numero_libranza" value="<?php echo $num_lib ?>" size="35" maxlength="35" ></td>
       <td width="96" height="27"><div align="center">
         <div align="center"><span class="label">Mes inicio :</span></div>
       </div></td>
       <td width="62"><input name="mi" type="text" class="campo" id="mi" value="00" size="2" maxlength="2" ></td>
       <td width="88"><div align="center"><span class="label">A&ntilde;o Inicio :</span></div></td>
       <td width="135"><input name="ai" type="text" class="campo" id="ai" value="0000" size="4" maxlength="4" ></td>
       <td>&nbsp;</td>
     </tr>
   </table> 
   </fieldset></td>
  </tr>
</table>
<p align="center">
  <input name = "guardar" type="submit" class="boton2" value="Guardar datos">
</p>
<p align="center">
    <input name="menu2" type="button" class="Estilo50" id="menu2" onClick="window.location.href='menu_credito.php'" value="IR AL MENU">
</p>
</form>
</body>
</html>