mostrar resultado de un modo un tanto especial

gralf · #1 (**permalink**) 14/12/2014, 05:35

tengo esta consulta

Código PHP:

Ver original$query_solostock149nc = "SELECT 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";
$solostock149nc = mysql_query($query_solostock149nc, $conexxion) or die(mysql_error());
$row_solostock149nc = mysql_fetch_assoc($solostock149nc);
$totalRows_solostock149nc = mysql_num_rows($solostock149nc);

me gustaría presentar los resultados en una tabla como esta, que es como vemos los stocks de este producto

[IMG][url=http://postimg.org/image/sp4m6mf8b/][img]http://s25.postimg.org/sp4m6mf8b/IMG_20141214_123617428.jpg[/img][/url][/IMG]

gralf · #2 (**permalink**) 14/12/2014, 12:00

intento con dreamweaver crear regiones repetidas, pero horizontalmente, que creo, es lo que necesito, no me deja hacerlo, o no se como.

de hecho he intentado para la primera fila, en l que solo deben salir dos resultados hacer la consulta con un limit 1,2, y da error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 2' at line 1

el código es este

Código PHP:

Ver original<?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;
}
}
 
mysql_select_db($database_conexxion, $conexxion);
$query_Recordset2 = "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;";
$Recordset2 = mysql_query($query_Recordset2, $conexxion) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
 
mysql_select_db($database_conexxion, $conexxion);
$query_solostock149nc = "SELECT 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";
$solostock149nc = mysql_query($query_solostock149nc, $conexxion) or die(mysql_error());
$row_solostock149nc = mysql_fetch_assoc($solostock149nc);
$totalRows_solostock149nc = mysql_num_rows($solostock149nc);
 
mysql_select_db($database_conexxion, $conexxion);
$query_stock1 = "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";
$stock1 = mysql_query($query_stock1, $conexxion) or die(mysql_error());
$row_stock1 = mysql_fetch_assoc($stock1);
$totalRows_stock1 = mysql_num_rows($stock1);
 
$maxRows_stock2 = 2;
$pageNum_stock2 = 0;
if (isset($_GET['pageNum_stock2'])) {
  $pageNum_stock2 = $_GET['pageNum_stock2'];
}
$startRow_stock2 = $pageNum_stock2 * $maxRows_stock2;
 
mysql_select_db($database_conexxion, $conexxion);
$query_stock2 = "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,1";
$query_limit_stock2 = sprintf("%s LIMIT %d, %d", $query_stock2, $startRow_stock2, $maxRows_stock2);
$stock2 = mysql_query($query_limit_stock2, $conexxion) or die(mysql_error());
$row_stock2 = mysql_fetch_assoc($stock2);
 
if (isset($_GET['totalRows_stock2'])) {
  $totalRows_stock2 = $_GET['totalRows_stock2'];
} else {
  $all_stock2 = mysql_query($query_stock2);
  $totalRows_stock2 = mysql_num_rows($all_stock2);
}
$totalPages_stock2 = ceil($totalRows_stock2/$maxRows_stock2)-1;
 
mysql_select_db($database_conexxion, $conexxion);
$query_stock3 = "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 2,2";
$stock3 = mysql_query($query_stock3, $conexxion) or die(mysql_error());
$row_stock3 = mysql_fetch_assoc($stock3);
$totalRows_stock3 = mysql_num_rows($stock3);
?>
<!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>1.49NC</title>
</head>
 
<body>
 
<p>pruebas</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<table width="80%" border="1">
  <tr>
    <td>&nbsp;</td>
    <td>0.00</td>
    <td>-0.25</td>
    <td>-0.50</td>
    <td>-0.75</td>
    <td>-1.00</td>
    <td>-1.25</td>
    <td>-1.50</td>
    <td>-1.75</td>
    <td>-2.00</td>
  </tr>
  <tr>
    <td>4.00</td>
    <td><?php echo $row_stock1['stock']; ?></td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>3.75</td>
    
    <td><?php do { ?>
          <?php echo $row_stock2['stock']; ?>
          <?php } while ($row_stock2 = mysql_fetch_assoc($stock2)); ?></td>
      <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>3.50</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>3.25</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>3.00</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>2.75</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>2.50</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>2.25</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td bgcolor="#333333">&nbsp;</td>
  </tr>
  <tr>
    <td>2.00</td>
    <td></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>1.75</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>1.50</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset2);
 
mysql_free_result($solostock149nc);
 
mysql_free_result($stock1);
 
mysql_free_result($stock2);
 
mysql_free_result($stock3);
?>

gralf · #3 (**permalink**) 14/12/2014, 13:01

Estoy intentando ver los dos links de la parte superior, en avisos, y los dos me dan error.