07/03/2008, 08:29
|
| | Fecha de Ingreso: febrero-2008
Mensajes: 24
Antigüedad: 16 años, 9 meses Puntos: 0 | |
Re: problema con listas <?php require_once('Connections/gastos.php'); ?>
<?php
mysql_select_db($database_gastos, $gastos);
$query_Recordset1 = "SELECT conseptos.NoCC FROM conseptos";
$Recordset1 = mysql_query($query_Recordset1, $gastos) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_gastos, $gastos);
$query_Recordset2 = "SELECT conseptos.NOMBRE_DEL_CONSEPTO FROM conseptos";
$Recordset2 = mysql_query($query_Recordset2, $gastos) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
mysql_select_db($database_gastos, $gastos);
$query_Recordset3 = "SELECT conceptos_gastos.NoCG FROM conceptos_gastos";
$Recordset3 = mysql_query($query_Recordset3, $gastos) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
mysql_select_db($database_gastos, $gastos);
$query_Recordset4 = "SELECT conceptos_gastos.NOMBRE_DEL_CONSEPTO_DE_GASTOS FROM conceptos_gastos";
$Recordset4 = mysql_query($query_Recordset4, $gastos) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);
mysql_select_db($database_gastos, $gastos);
$query_Recordset5 = "SELECT conceptos_gastos.ING_EGR FROM conceptos_gastos";
$Recordset5 = mysql_query($query_Recordset5, $gastos) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);
mysql_select_db($database_gastos, $gastos);
$query_Recordset6 = "SELECT conceptos_gastos.NoC FROM conceptos_gastos";
$Recordset6 = mysql_query($query_Recordset6, $gastos) or die(mysql_error());
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
$totalRows_Recordset6 = mysql_num_rows($Recordset6);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>hugos</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
function suma(){
a=document.formulario;
a.valor5.value=parseFloat(a.valor1.value)+parseFlo at(a.valor2.value)+parseFloat(a.valor3.value)
+parseFloat(a.valor4.value)+parseFloat(a.valor11.v alue)+parseFloat(a.valor12.value)+parseFloat(a.val or13.value)
+parseFloat(a.valor14.value)*parseFloat(.15);
}
</script>
<style type="text/css">
<!--
.Estilo1 {font-size: xx-large}
-->
</style>
<link href="file:///C|/Archivos%20de%20programa/Apache%20Group/Apache2/GASTOS/estilo14.css" rel="stylesheet" type="text/css">
<link href="esttilo15.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.Estilo15 {font-family: "Times New Roman", Times, serif}
.Estilo16 {font-size: x-small}
-->
</style>
</head>
<body>
<table width="525" height="178" border="0" align="center">
<tr>
<td height="174"><strong><img src="HUGOSS_prueba%20FORMA%20CENTROS%20DE%20COSTOS _8493_image002.jpg" width="160" height="61"></strong></td>
<td><p align="center"><strong><span class="Estilo1">SOLICITUD DE GASTOS</span></strong></p>
<p align="center"><strong>Fecha de Solicitud:
<!-- #BeginDate format:fcSw1m -->Jueves, 6 Marzo, 2008 17:32<!-- #EndDate -->
<br />
</strong><strong>Fecha de Comprobacion:</strong>
<input type="text" name="textfield" />
</p></td>
<td><img src="HUGOSS_prueba%20FORMA%20CENTROS%20DE%20COSTOS _8493_image002.jpg" width="160" height="61"></td>
</tr>
</table>
<p> </p>
<table width="893" height="36" border="5">
<tr>
<td width="26"><span class="estilo14">NoC</span></td>
<td width="131"><span class="estilo14">NOMBRE DEL CONCEPTO </span></td>
<td width="36"><span class="estilo14">NoCG</span></td>
<td width="263" class="estilo14">NOMBRE DEL CONCEPTO DE GASTOS </td>
<td width="69"><span class="estilo14">EGR/ING</span></td>
<td width="147"><div align="center"><span class="estilo14">SUB-TOTAL 0% </span></div></td>
<td width="167"><div align="center"><span class="estilo14">SUB-TOAL15%</span></div></td>
</tr>
</table>
<form action="" method="post" name="formulario" id="formulario">
<p>
<select name="select" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset1['NoCC']?>"><?php echo $row_Recordset1['NoCC']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
<select name="select2" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset2['NOMBRE_DEL_CONSEPTO']?>"><?php echo $row_Recordset2['NOMBRE_DEL_CONSEPTO']?></option>
<?php
} while ($row_Recordset2 = mysql_fetch_assoc($Recordset2));
$rows = mysql_num_rows($Recordset2);
if($rows > 0) {
mysql_data_seek($Recordset2, 0);
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
}
?>
</select>
<select name="select3" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset6['NoC']?>"><?php echo $row_Recordset6['NoC']?></option>
<?php
} while ($row_Recordset6 = mysql_fetch_assoc($Recordset6));
$rows = mysql_num_rows($Recordset6);
if($rows > 0) {
mysql_data_seek($Recordset6, 0);
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
}
?>
</select>
<select name="select4" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset4['NOMBRE_DEL_CONSEPTO_DE_GASTOS']?>"><?php echo $row_Recordset4['NOMBRE_DEL_CONSEPTO_DE_GASTOS']?></option>
<?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
$rows = mysql_num_rows($Recordset4);
if($rows > 0) {
mysql_data_seek($Recordset4, 0);
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
}
?>
</select>
<select name="select5" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset5['ING_EGR']?>"><?php echo $row_Recordset5['ING_EGR']?></option>
<?php
} while ($row_Recordset5 = mysql_fetch_assoc($Recordset5));
$rows = mysql_num_rows($Recordset5);
if($rows > 0) {
mysql_data_seek($Recordset5, 0);
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
}
?>
</select>
<input name="valor1" type="text" id="valor1">
<input name="valor11" type="text" id="valor11">
</p>
<p>
<select name="select6" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset1['NoCC']?>"><?php echo $row_Recordset1['NoCC']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
<select name="select9" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset2['NOMBRE_DEL_CONSEPTO']?>"><?php echo $row_Recordset2['NOMBRE_DEL_CONSEPTO']?></option>
<?php
} while ($row_Recordset2 = mysql_fetch_assoc($Recordset2));
$rows = mysql_num_rows($Recordset2);
if($rows > 0) {
mysql_data_seek($Recordset2, 0);
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
}
?>
</select>
<select name="select12" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset6['NoC']?>"><?php echo $row_Recordset6['NoC']?></option>
<?php
} while ($row_Recordset6 = mysql_fetch_assoc($Recordset6));
$rows = mysql_num_rows($Recordset6);
if($rows > 0) {
mysql_data_seek($Recordset6, 0);
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
}
?>
</select>
<select name="select15" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset4['NOMBRE_DEL_CONSEPTO_DE_GASTOS']?>"><?php echo $row_Recordset4['NOMBRE_DEL_CONSEPTO_DE_GASTOS']?></option>
<?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
$rows = mysql_num_rows($Recordset4);
if($rows > 0) {
mysql_data_seek($Recordset4, 0);
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
}
?>
</select>
<select name="select18" class="esttilo5">
<option></BLANK></option>
<?php
do {
?>
<option value="<?php echo $row_Recordset5['ING_EGR']?>"><?php echo $row_Recordset5['ING_EGR']?></option>
<?php
} while ($row_Recordset5 = mysql_fetch_assoc($Recordset5));
$rows = mysql_num_rows($Recordset5);
if($rows > 0) {
mysql_data_seek($Recordset5, 0);
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
}
?>
</select> |