if(isset($_SESSION[SESSION_CLIENTE][customer_id])){
$select = mysqli_query($db,"select categorias.category,categorias.cat_id,categorias.cat_father_id,
clientes.categoria_id,clientes.customer_id
from
stock_categoria as categorias,
stock_categorias_clientes as clientes,
stock_articulos as articulos
where categorias.cat_father_id='0' and categorias.ver = 'Y' and categorias.cat_id=clientes.categoria_id and clientes.customer_id='".$_SESSION[SESSION_CLIENTE][customer_id]."' AND articulos.cat_id=categorias.cat_id group by categorias.cat_id");
}else{
$select = mysqli_query($db,"select categorias.category,categorias.cat_id,categorias.cat_father_id
from
stock_categoria as categorias
where categorias.cat_father_id='0' and categorias.ver = 'Y' order by categorias.category");
}
while ($row = mysqli_fetch_array($select)){
$category = $row[category];
$cat_id = $row[cat_id];
$sql_countar1 = mysqli_query($db,"select * from stock_categoria where cat_father_id='".$cat_id."' and ver='Y' order by category");
$totales1 = mysqli_num_rows($sql_countar1);
if($totales1 == 0){ ?>
}else{
if(isset($_SESSION[SESSION_CLIENTE][customer_id])){
$result = mysqli_query($db,"select categorias.category,categorias.cat_id,categorias.cat_father_id,
clientes.categoria_id,clientes.customer_id
from
stock_categoria as categorias,
stock_categorias_clientes as clientes,
stock_articulos as articulos
where categorias.cat_father_id='".$row[cat_id]."' and categorias.cat_id=clientes.categoria_id and categorias.ver = 'Y' and clientes.customer_id='".$_SESSION[SESSION_CLIENTE][customer_id]."' AND articulos.cat_id=categorias.cat_id $articuloses group by categorias.cat_id");
}else{
$result = mysqli_query($db,"select categorias.category,categorias.cat_id,categorias.cat_father_id
from
stock_categoria as categorias
where categorias.cat_father_id='".$rowc[cat_id]."' and categorias.ver = 'Y' order by categorias.category");
} ?>
if(empty($_REQUEST[catid])){
if(!empty($_REQUEST[articulo_nombre])){
$selects = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id $articuloses group by articulos.marca_id order by marcas.marca asc");
}else{
//$selects = mysqli_query($db,"select * from stock_marcas order by marca");
$selects = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc");
}
}else{
$selects = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.cat_id='".$_REQUEST[catid]."' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc");
}
$totalmarcas = mysqli_num_rows($selects);
$mitadmarcas = $totalmarcas/2;
if($mitadmarcas % 2){ $mitad = $mitadmarcas; $mitad = round($mitadmarcas); }else{ $mitad = round($mitadmarcas); }
//echo $mitadmarcas. "," .$mitad. "," .$entra;
if (empty($_REQUEST[catid])){
if(!empty($_REQUEST[articulo_nombre])){
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id $articuloses group by articulos.marca_id order by marcas.marca asc LIMIT 0, $mitad");
}else{
//$select = mysqli_query($db,"select * from stock_marcas order by marca LIMIT 0, $mitad");
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc LIMIT 0, $mitad");
}
}else{
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.cat_id='".$_REQUEST[catid]."' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc LIMIT 0, $mitad");
}
while ($row = mysqli_fetch_array($select)){
?>
} ?>
if( ($_REQUEST[catid]=="-1") OR (empty($_REQUEST[catid])) ){
if(!empty($_REQUEST[articulo_nombre])){
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id $articuloses group by articulos.marca_id order by marcas.marca asc LIMIT $mitad, $totalmarcas");
}else{
//$select = mysqli_query($db,"select * from stock_marcas order by marca LIMIT $mitad, $totalmarcas");
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc LIMIT $mitad, $totalmarcas");
}
}else{
$select = mysqli_query($db,"select marcas.marca_id, marcas.marca,
articulos.articulo_id,articulos.nombre,articulos.marca_id,articulos.cat_id,articulos.visible
from
stock_articulos as articulos,
stock_marcas as marcas
where articulos.visible='Y' AND articulos.nopublicar='N' AND articulos.cat_id='".$_REQUEST[catid]."' AND articulos.marca_id=marcas.marca_id group by articulos.marca_id order by marcas.marca asc LIMIT $mitad, $totalmarcas");
}
while ($row = mysqli_fetch_array($select)){
?>
} ?>
Nuestras Marcas
$queryp = "select * from stock_banners where seccion='F' order by orden asc";
$stmp = mysqli_query($db,$queryp);
while($m = mysqli_fetch_array($stmp)){
?>