if($_REQUEST['id'])
$ext = ' AND md5(t1.rubros_id) = "'.$_REQUEST['id'].'"';
if($_REQUEST['tipo'])
$ext1 = ' AND md5(t3.id) = "'.$_REQUEST['tipo'].'"';
$SQL = 'SELECT COUNT(*) AS n
FROM productos t1
INNER JOIN rubros t2 ON (t1.rubros_id = t2.id)
INNER JOIN rubros t4 ON (t2.rubros_id = t4.id)
INNER JOIN secciones t3 ON (t1.secciones_id = t3.id)
WHERE 1
AND t1.borrado= "N"
AND t1.estado = "Y"
AND t3.id <> 4
'.$ext.'
'.$ext1.';';
$rs = mysql_query($SQL);
$fp = mysql_fetch_assoc($rs);
mysql_free_result($rs);
//----
$max_show = 8;
$desde = 0;
$actual = 0;
//---
$paginado = NULL;
$paginas = ceil($fp['n']/$max_show);
//---
if($_REQUEST['p']!=''){
$actual = $_REQUEST['p']-1;
$desde = $actual*$max_show;
}
//-----------
$paginado = array();
for($i=0;$i<$paginas;$i++){
if($i==$actual){
$paginado[] = 1+$i;
}else{
$paginado[] = '
'.(1+$i).'';
}
}
$paginado = '
'.implode(' | ',$paginado).'
';
$SQL = 'SELECT t1.nombre, t1.imagen_ch, t1.copete, t2.rubro AS subrubro, t4.rubro, t4.id, t2.id AS idSub,
t3.seccion, md5(t1.id) AS idU
FROM productos t1
INNER JOIN rubros t2 ON (t1.rubros_id = t2.id)
INNER JOIN rubros t4 ON (t2.rubros_id = t4.id)
INNER JOIN secciones t3 ON (t1.secciones_id = t3.id)
WHERE 1
AND t1.borrado= "N"
AND t1.estado = "Y"
AND t2.borrado = "N" AND t2.estado = "Y"
AND t4.borrado = "N" AND t4.estado = "Y"
AND t3.id <> 4
'.$ext.'
'.$ext1.'
GROUP BY t1.id
ORDER BY t4.rubro, subrubro, t1.orden
LIMIT '.$desde.','.$max_show.';';
$rs = $db->db_query($SQL);
$f = $db->db_fetch_assoc($rs);
if($f){
$rubro = NULL;
$sub_rubro = NULL;
?>
if($_REQUEST['tipo']){?>
Notice: Undefined variable: f in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 107
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 107
}else{?>
echo 'PRODUCTOS ';?>
}?>
do{?>
if($rubro != $f['id'] || is_null($f['id'])){?>
Notice: Undefined variable: f in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 116
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 116
$rubro = $f['id'];
}?>
if($sub_rubro != $f['idSub']){?>
Notice: Undefined variable: f in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 123
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 123
$sub_rubro = $f['idSub'];
}?>
if($f['imagen_ch']){?>

}else{?>

}?>
Notice: Undefined variable: f in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 139
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 139
}while($f = $db->db_fetch_assoc($rs));?>
}?>
Notice: Undefined variable: paginado in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 149
if($_REQUEST['tipo'])
$ext2 = ' AND md5(t4.id) = "'.$_REQUEST['tipo'].'"';
$SQL = 'SELECT t1.rubro AS subrubro, t2.rubro, t2.id, md5(t1.id) AS idU, md5(t4.id) AS IDTIPO, t4.seccion
FROM rubros t1
INNER JOIN rubros t2 ON (t1.rubros_id = t2.id AND t2.estado ="Y" AND t2.borrado ="N" )
INNER JOIN productos t3 ON (t1.id = t3.rubros_id)
INNER JOIN secciones t4 ON (t3.secciones_id = t4.id)
WHERE 1
AND t1.estado = "Y"
AND t1.borrado = "N"
'.$ext2.'
GROUP BY t1.rubro
ORDER BY t1.rubro';
$res = $db->db_query($SQL);
$fc = $db->db_fetch_assoc($res);
if($fc){
$rubro = NULL;
?>
do{?>
if($rubro != $fc['id']){?>
if($rubro != NULL){?>
}?>
Notice: Undefined variable: fc in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 185
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/fullmaq-maquinaria.php on line 185
}?>