well, studying a little I´ve written this
<?php require_once('Connections/conexxion.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_conexxion, $conexxion);
$query_Recordset1 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 1";
$Recordset1 = mysql_query($query_Recordset1, $conexxion) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_conexxion, $conexxion);
$query_fila2 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 1,2";
$fila2 = mysql_query($query_fila2, $conexxion) or die(mysql_error());
$row_fila2 = mysql_fetch_assoc($fila2);
$totalRows_fila2 = mysql_num_rows($fila2);
mysql_select_db($database_conexxion, $conexxion);
$query_fila3 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 3,3";
$fila3 = mysql_query($query_fila3, $conexxion) or die(mysql_error());
$row_fila3 = mysql_fetch_assoc($fila3);
$totalRows_fila3 = mysql_num_rows($fila3);
mysql_select_db($database_conexxion, $conexxion);
$query_fila4 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 6,4";
$fila4 = mysql_query($query_fila4, $conexxion) or die(mysql_error());
$row_fila4 = mysql_fetch_assoc($fila4);
$totalRows_fila4 = mysql_num_rows($fila4);
mysql_select_db($database_conexxion, $conexxion);
$query_fila5 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 10,5";
$fila5 = mysql_query($query_fila5, $conexxion) or die(mysql_error());
$row_fila5 = mysql_fetch_assoc($fila5);
$totalRows_fila5 = mysql_num_rows($fila5);
mysql_select_db($database_conexxion, $conexxion);
$query_fila6 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 15,6";
$fila6 = mysql_query($query_fila6, $conexxion) or die(mysql_error());
$row_fila6 = mysql_fetch_assoc($fila6);
$totalRows_fila6 = mysql_num_rows($fila6);
mysql_select_db($database_conexxion, $conexxion);
$query_fila7 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 21,7";
$fila7 = mysql_query($query_fila7, $conexxion) or die(mysql_error());
$row_fila7 = mysql_fetch_assoc($fila7);
$totalRows_fila7 = mysql_num_rows($fila7);
mysql_select_db($database_conexxion, $conexxion);
$query_fila8 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 28,8";
$fila8 = mysql_query($query_fila8, $conexxion) or die(mysql_error());
$row_fila8 = mysql_fetch_assoc($fila8);
$totalRows_fila8 = mysql_num_rows($fila8);
mysql_select_db($database_conexxion, $conexxion);
$query_fila9 = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos) as stock, cilindro, esfera FROM movimiento join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro on cilindro.id_cil=rx.id_cil join esfera on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc limit 36,25";
$fila9 = mysql_query($query_fila9, $conexxion) or die(mysql_error());
$row_fila9 = mysql_fetch_assoc($fila9);
$totalRows_fila9 = mysql_num_rows($fila9);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>test</title>
</head>
<body>
<table align=center>
<tr>
<td width="40px;" align="center"> </td>
<td width="40px;" align="center">0.00</td>
<td width="40px;" align="center">-0.25</td>
<td width="40px;" align="center">-0.50</td>
<td width="40px;" align="center">-0.75</td>
<td width="40px;" align="center">-1.00</td>
<td width="40px;" align="center">-1.25</td>
<td width="40px;" align="center">-1.50</td>
<td width="40px;" align="center">-1.75</td>
<td width="40px;" align="center">-2.00</td>
</tr>
<tr>
<td align="center"><?php echo $row_Recordset1['esfera']; ?></td>
<td align="center"><?php echo $row_Recordset1['stock']; ?></td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila2['esfera']; ?></td>
<?php do { ?><td align="center">
<?php echo $row_fila2['stock']; ?>
</td><?php } while ($row_fila2 = mysql_fetch_assoc($fila2)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila3['esfera']; ?></td>
<?php do { ?><td align="center">
<?php echo $row_fila3['stock']; ?>
</td><?php } while ($row_fila3 = mysql_fetch_assoc($fila3)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila4['esfera']; ?></td>
<?php do { ?>
<td align="center"><?php echo $row_fila4['stock']; ?></td>
<?php } while ($row_fila4 = mysql_fetch_assoc($fila4)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila5['esfera']; ?></td>
<?php do { ?>
<td align="center"><?php echo $row_fila5['stock']; ?></td>
<?php } while ($row_fila5 = mysql_fetch_assoc($fila5)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila6['esfera']; ?></td>
<?php do { ?>
<td align="center"><?php echo $row_fila6['stock']; ?></td>
<?php } while ($row_fila6 = mysql_fetch_assoc($fila6)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila7['esfera']; ?></td>
<?php do { ?>
<td align="center"><?php echo $row_fila7['stock']; ?></td>
<?php } while ($row_fila7 = mysql_fetch_assoc($fila7)); ?>
<td align="center" bgcolor="#0000FF"> </td>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<tr>
<td align="center"><?php echo $row_fila8['esfera']; ?></td>
<?php do { ?>
<td align="center"><?php echo $row_fila8['stock']; ?></td>
<?php } while ($row_fila8 = mysql_fetch_assoc($fila8)); ?>
<td align="center" bgcolor="#0000FF"> </td>
</tr>
<?php do { ?>
<tr>
<td align="center"><?php echo $row_fila9['esfera']; ?></td>
<td align="center"><?php echo $row_fila9['stock']; ?></td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<?php } while ($row_fila9 = mysql_fetch_assoc($fila9)); ?>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
</table>
<?php
$columnas = 9; # Número de columnas (variable)
for ($i=1; $row = mysql_fetch_row ($Recordset1); $i++) {
$resto = ($i % $columnas); # Número de celda del <tr> en que nos encontramos
if ($resto == 1) {echo "<tr>";} # Si es la primera celda, abrimos <tr>
echo "<td width=\"40px;\" align=\"center\">$row[1]</td>";
if ($resto == 0) {echo "</tr>";} # Si es la última celda, cerramos </tr>
}
if ($resto <> 0) { # Si el resultado no es múltiple de $columnes acabamos de rellenar los huecos
$ajust = $columnas - $resto; # Número de huecos necesarios
for ($j = 0; $j < $ajust; $j++) {echo "<td> </td>";}
echo "</tr>"; # Cerramos la última línea </tr>
}
mysql_close($connexion);
echo "</table>";
?>
</body>
</html>
<?php
mysql_free_result($fila1);
mysql_free_result($Recordset1);
mysql_free_result($fila2);
mysql_free_result($fila3);
mysql_free_result($fila4);
mysql_free_result($fila5);
mysql_free_result($fila6);
mysql_free_result($fila7);
mysql_free_result($fila8);
mysql_free_result($fila9);
mysql_free_result($consulta);
?>
with this result
now I have 25 rows in the table that can be filled up to 9 results, you can see that there are 9 results for 2.00, 9 for 1.75 and so on but I am unable to achive this.
I can see that creating a new query for every row is a solution, but 25 + 9 more querys.... maybe too many queries?