aqui esta el codigo
Código PHP:
<?php
$obraclavefrente = $_POST['obraclavefrente'];
$obranombrefrente = $_POST['obranombrefrente'];
$ubicacionfrente = $_POST['ubicacionfrente'];
$clavepartida = $_POST['clavepartida'];
$frentecalle = $_POST['frentecalle'];
$frentenumero = $_POST['frentenumero'];
$frentecolonia = $_POST['frentecolonia'];
$clavedestajista = $_POST['clavedestajista'];
$nombredestajista = $_POST['nombredestajista'];
$etapa = $_POST['etapa'];
$partidafecha = $_POST['partidafecha'];
$finalfecha = $_POST['finalfecha'];
$ano = $_POST['ano'];
$fecha = $_POST['fecha'];
$clavepaquete = $_POST['clavepaquete'];
$numeroestimacionletra = $_POST['numeroestimacionletra'];
$numeroestimacion = $_POST['numeroestimacion'];
$descpaquete = $_POST['descpaquete'];
$connection = mysql_connect("localhost","administrador","administrador");
mysql_select_db("destajos",$connection);
$datospaquete = mysql_query("SELECT * FROM paquetel where clavefrente = '$obraclavefrente' and clavepaquete = '$clavepaquete' and clavepartida = '$clavepartida'",$connection);
echo "<table>";
echo "<tr><td><font color = \"blue\" size = \"3\" face = \"arial\"><b>ESTIMACIONES (PASO3)<b></font></td></tr>";
echo "</table><br><br>";
echo "<table width = \"900px\">";
echo "<tr><td><font color = \"blue\" size = \"2\" face = \"arial\"><b>OBRA:</b></font><font color = \"green\" size = \"2\"><b>$obraclavefrente-$obranombrefrente</b></font></td>";
echo "<td><font color = \"blue\" size = \"2\" face = \"arial\"><b>FECHA:</b></font><font color =\"green\" size =\"2\"><b>$fecha</b></font></td>";
echo "<td><font color =\"blue\" size = \"2\" face = \"arial\"><b>LOCALIDAD:</b></font><font color = \"green\" size = \"2\"><b>$frentecalle $frentenumero Col. $frentecolonia</b></font></td></tr>";
echo "<tr><td><font color = \"blue\" size = \"2\" face = \"arial\"><b>FRENTE:</b></font<td><font color = \"green\" size = \"2\"><b>$ubicacionfrente</b></font></td>";
echo "<td><font color = \"blue\" size = \"2\" face = \"arial\"><b>ETAPA:</b></font><font color = \"green\" size = \"2\"><b>$etapa</b></font></td>";
echo "<td><font color = \"blue\" size = \"2\" face = \"arial\"><b>DESTAJISTA:</b></font><font color = \"green\" size = \"2\"><b>$clavedestajista-$nombredestajista</b></font></td></tr>";
echo "<tr><td><font color = \"blue\" size = \"2\" face = \"arial\"><b>PERIODO DE:</b></font><font color = \"green\" size = \"2\"><b>$partidafecha</b></font>*<font color = \"blue\" size = \"2\" face = \"arial\"><b>AL:</b></font><font color = \"green\" size = \"2\"><b>$finalfecha $ano</b></font></td>";
echo "<td><font color = \"blue\" size = \"2\" face = \"arial\"><b>ESTIMANCION NUMERO:</b></font><font color = \"green\" size = \"2\"><b>**$numeroestimacion</b></font></Td></tr>";
echo "<tr><td><font color =\"blue\" size = \"2\" face = \"arial\"><b>TRABAJOS DE:</b></font><font color = \"green\" size = \"2\"><b>$clavepartida</b></font></td>";
echo "<td><font color = \"blue\" size = \"2\" face = \"arial\"><b>ESTIMACION NUMERO(con letra):</b></font><td><font color = \"green\" size = \"2\"><b>$numeroestimacionletra</b></font></td></tr>";
echo "</table><br><br>";
echo "<table border = \"1\">";
echo "<th><font size = \"2\"><b>Clave Concepto</b></font></th>";
echo "<th><font size = \"2\"><b>Concepto</b></font></th>";
echo "<th><font size = \"2\"><b>Unidad</b></font></th>";
echo "<th><font size = \"2\"><b>Precio Unitario</b></th>";
echo "<th><font size = \"2\"><b>Cantidad</b></th>";
$datospaquete = mysql_query("SELECT * FROM paquetel where clavefrente = '$obraclavefrente' and clavepaquete = '$clavepaquete' and clavepartida = '$clavepartida' and descpaquete = '$descpaquete'",$connection);
$bucle= while($rows = mysql_fetch_assoc($datospaquete)){
echo "<form name = \"datos\" method = \"POST\" action = \"estimacionpaso4.php\">";
echo "<tr><td><font size = \"1\">$rows[claveconcepto]</td>";
echo "<td><font size = \"1\">$rows[descconcepto]</font></td>";
echo "<td><font size = \"1\">$rows[unidad]</font></td>";
echo "<td><font size = \"1\">$rows[pu]</font></td>";
echo "<td><font size = \"1\">$rows[cantidad]</font></td>";
echo "<td><input type = \"text\" name = \"volumennuevo\" maxlenght = \"25\" size = \"10\"></td>";
echo "<td><input type = \"text\" name = \"importenuevo\" maxlenght = \"25\" size = \"10\"></td>";
echo "<td><input type = \"submit\" value = \"PASO (4)\"></td>";
$estimaciona = mysql_query("SELECT ultimo FROM estimacion where clavefrente = '$obraclavefrente' and clavepaquete = '$clavepaquete' and clavepartida = '$clavepartida'",$connection);
while($rows1 = mysql_fetch_assoc($estimaciona)){
echo "<td><font size = \"1\">$rows1[volumenac]</font></td>";
echo "<td><font size = \"1\">$rows1[importeac]</font></td>";
echo "<td><input type = \"text\" name = \"suma1\"></td>";
echo "<td><input type = \"submit\" value = \"PASO (4)\"></td></tr>";
echo "<input type = \"hidden\" name = \"obraclavefrente\" value = \"$obraclavefrente\">";
echo "<form>";
}
}
?>