ESTIMADOS.
De que manera se debe hacer para almacenar en un arreglo los datos que ingreso.
<html>
<head><link rel="stylesheet" type="text/css" href="css/buscar-en-tabla.css"></head>
<body>
<?php
include "conexionAserradero.php";
?>
<?php
echo "$dato";
if (isset($_GET['dato']))
{
$dato = $_GET['dato'];
}
$sql = ( " SELECT
p.profolio,
p.profecha,
ep.profolio,
ep.esqcodigo,
s.esqcodigo,
ps.prodtipo,
ps.prodmercado,
ps.prodescuadria,
ps.prodlargo,
ps.prodpzas,
ps.prodvolumen,
s.simtrozosconsumo,
r.consumotrozos
FROM
programa AS p,
esquemaprograma AS ep,
simulaciones AS s,
produccionsimulada AS ps,
real AS r
WHERE
p.profolio='$dato' AND
p.profolio=ep.profolio AND
ep.esqcodigo=s.esqcodigo AND
s.simcodigo=ps.simcodigo AND
s.item=ps.item AND
ep.esqcodigo=r.esqcodigo
LIMIT
5
");
$result = pg_query ( $dbconn, $sql ) or die ("ERROR EN CONSULTA");
$row = pg_fetch_assoc($result);
?>
<div id="divContenedor">
<div id="divInfo">
<h1>
USNR
</h1>
<p>---</a></p>
<form action="index2.php">
<input type="submit" name="volver" value="volver"></form>
</div>
<table border="1" id="tblTabla" width="630" align="center">
<thead>
<tr>
<td colspan="7" ></td>
<td>TROZOS REALES</td>
<td>TROZOS SIMULADOS</td>
</tr>
<tr>
<td colspan="7"></td>
<td><?php echo $row["consumotrozos"]; ?></td>
<td><?php echo $row["simtrozosconsumo"]; ?></td>
</tr>
<tr>
<td></td>
<th>FOLIO</th>
<th>TIPO</th>
<th>MERCADO</th>
<th>ESCUADRIA</th>
<th>LARGO</th>
<th>VOLUMEN</th>
<th>TROZOS SIMULADOS</th>
<th>TROZOS REALES</th>
</tr>
</thead>
<tbody>
<?php
$result = pg_query ( $dbconn, $sql ) or die ("ERROR EN CONSULTA");
while ($row = pg_fetch_assoc($result)){
?>
<?php
$sum_pzas = $sum_pzas + $row["prodpzas"];
$sum_volumen = $sum_volumen + number_format($row["prodvolumen"], 3,'.','');
$prod_volumen = number_format($row["prodvolumen"], 3,'.','')/$sum_volumen;
$sum_prod_volumen = sum_prod_volumen + $prod_volumen;
$prod_volumen_real =(number_format($row["prodvolumen"])*$row["consumotrozos"])/$row["simtrozosconsumo"];
$sum_prod_volumen_real = $sum_prod_volumen_real + prod_volumen_real;
?>
<tr>
<td></td>
<td><?php echo $row["profolio"]; ?></td>
<td><?php echo $row["prodtipo"]; ?></td>
<td><?php echo $row["prodmercado"]; ?></td>
<td><?php echo $row["prodescuadria"]; ?></td>
<td><?php echo $row["prodlargo"]; ?></td>
<td><?php echo number_format($row["prodvolumen"], 3,'.',''); ?></t>
<td><?php echo number_format($prod_volumen, 3,'.',''); ?></td>
<td><?php echo number_format($prod_volumen_real, 3,'.',''); ?></td>
</tr>
<?php
}
?>
<td colspan="5" align="center">TOTAL</td>
<td><?php echo $sum_pzas; ?></td>
<td><?php echo $sum_volumen; ?></td>
<td><?php echo number_format($sum_prod_volumen, 3,'.',''); ?></td>
<td><?php echo $sum_prod_volumen_real; ?></td>
</tbody>
<tfoot>
<tr>
<td colspan="9">
--Aserradero Arauco-Planta Horcones II-USNR--
</td>
</tr>
</tfoot>
</table>
</div>
</body>
</html>