From 90f3f0a4486a975fe8aa56aff6f98cd01755dcd7 Mon Sep 17 00:00:00 2001 From: administrador User Date: Fri, 6 Feb 2009 20:04:25 +0100 Subject: [PATCH] =?utf8?q?Agrupaci=C3=B3n=20de=20lista=20de=20mupis/pantal?= =?utf8?q?las=20mas=20logica.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- contenido/mupis+pantallas.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/contenido/mupis+pantallas.php b/contenido/mupis+pantallas.php index 10c819f..dc3f5ec 100644 --- a/contenido/mupis+pantallas.php +++ b/contenido/mupis+pantallas.php @@ -84,7 +84,7 @@ function verPantallas($usuario="", $pantalla=""){ if ($usuario) { $WHERE = " WHERE codigo='".$usuario."'"; } - $q = "SELECT Id, codigo_pantalla_mupi, codigo_mupi, (SELECT CONCAT(b.codigo_mupi, '. ' , (SELECT ubicacion FROM ".TBL_STREETS." AS c WHERE c.codigo_calle = b.codigo_calle), ', ' , b.direccion) FROM ".TBL_MUPI." as b WHERE b.codigo_mupi=a.codigo_mupi) as codigo_mupi_traducido, codigo_pedido, (SELECT CONCAT(codigo_pedido, '. ' , o.descripcion) FROM ".TBL_MUPI_ORDERS." as o WHERE o.codigo_pedido = a.codigo_pedido) as codigo_pedido_traducido, catorcena, foto_real, codigo_evento FROM ".TBL_MUPI_FACES." as a WHERE catorcena = $Catorcena ORDER BY codigo_pantalla_mupi;"; + $q = "SELECT Id, codigo_pantalla_mupi, codigo_mupi, (SELECT CONCAT(b.codigo_mupi, '. ' , (SELECT ubicacion FROM ".TBL_STREETS." AS c WHERE c.codigo_calle = @calle := b.codigo_calle), ', ' , b.direccion) FROM ".TBL_MUPI." as b WHERE b.codigo_mupi=a.codigo_mupi) as codigo_mupi_traducido, codigo_pedido, (SELECT CONCAT(codigo_pedido, '. ' , o.descripcion) FROM ".TBL_MUPI_ORDERS." as o WHERE o.codigo_pedido = a.codigo_pedido) as codigo_pedido_traducido, catorcena, foto_real, codigo_evento, @calle as codigo_calle2 FROM ".TBL_MUPI_FACES." as a WHERE catorcena = $Catorcena ORDER BY codigo_calle2, codigo_mupi, codigo_pantalla_mupi;"; //echo $q; $result = $database->query($q); if ( !$result ) { -- 2.11.4.GIT