}?>
$SQL = 'SELECT t1.imagen_ch, t1.imagen_gr, t1.epigrafe
FROM imagenes t1
WHERE 1
AND t1.borrado = "N"
AND t1.productos_id = '.$f['id'].';';
$rsi = $db->db_query($SQL);
$fi = $db->db_fetch_assoc($rsi);
if($fi){?>
Galería de imágenes
do{?>
if($fi['imagen_ch']){?>
}else{?>
}?>
}while($fi = $db->db_fetch_assoc($rsi));?>
}?>
$SQL = 'SELECT *
FROM archivos t1
WHERE 1
AND t1.borrado = "N"
AND t1.productos_id = '.$f['id'].';';
$rsa = $db->db_query($SQL);
$fa = $db->db_fetch_assoc($rsa);
if($fa){?>
}while($fa = $db->db_fetch_assoc($rsa));?>
}?>
$SQL = 'SELECT *
FROM videos t1
WHERE 1
AND t1.borrado = "N"
AND t1.productos_id = '.$f['id'].';';
$rsv = $db->db_query($SQL);
$fv = $db->db_fetch_assoc($rsv);
if($fv){?>
Videos
do{?>
if($fv['imagen_ch']){?>
}else{?>
}?>
}while($fv = $db->db_fetch_assoc($rsv));?>
}?>
$SQL = 'SELECT t1.rubro AS subrubro, t2.rubro, t2.id, md5(t1.id) AS idU, md5(t4.id) AS idS
FROM rubros t1
LEFT OUTER 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 AND t3.estado = "Y" AND t3.borrado = "N")
INNER JOIN secciones t4 ON (t3.secciones_id = t4.id)
WHERE 1
AND t1.estado = "Y"
AND t1.borrado = "N"
AND t4.id = '.$f['IDSEC'].'
GROUP BY t1.rubro';
$res = $db->db_query($SQL);
$fc = $db->db_fetch_assoc($res);
if($fc){
$rubro = NULL;
?>