<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PRUEBA</title>
<link rel="stylesheet" type="text/css" href="css/flexigrid/flexigrid.css">
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/flexigrid.js"></script>
</head>
<body>
<table class="prueba">
<thead>
<tr>
<th width="100">Producto</th>
<th width="100">Stock Inicial</th>
<th width="100">Stock Actual</th>
<th width="100">Vendidos</th>
<th width="100">Precio Costo</th>
<th width="100">Precio Venta</th>
<th width="100">TOTAL VENDIDO</th>
</tr>
</thead>
<tbody>
<?php
foreach($productos as $producto) {
$stock = $producto['s_inicial'];
$precio_costo = $producto['p_costo'];
$producto = $producto['nombre'];
$precio_venta = $producto['p_venta'];
$vendidos = $producto['vendidos'];
$totalstock = $stock - $vendidos;
$totalventas = $vendidos * $precio_venta;
echo "<tr>";
echo "<td>".$producto."</td>";
echo "<td>".$stock." unidades</td>";
echo "<td>".$totalstock." unidades</td>";
echo "<td>".$vendidos." unidades</td>";
echo "<td>$".$precio_costo."</td>";
echo "<td>$".$precio_venta."</td>";
echo "<td>$".$totalventas."</td>";
echo "</tr>";
}
?>
</tbody>
</table>
<script type="text/javascript">
$('.prueba').flexigrid({height:'auto',striped:false,sortable:true});
</script>
</body>
</html>