Thank you Ray, I did this, but the information of the products is repeating the same for all categories:
<?php
$breadcrumbs = new WA_MySQLi_RS("breadcrumbs",$conn_mysqli_base,0);
$breadcrumbs->setQuery("SELECT * FROM subcategoria, categoria WHERE categoria.categoriaID = subcategoria.subcatCATID AND subcategoria.subcatCATID = ?");
$breadcrumbs->bindParam("i", "".$_GET['cat'] ."", "-1"); //colname
$breadcrumbs->execute();
?>
<?php
$fotos = new WA_MySQLi_RS("fotos",$conn_mysqli_base,0);
$fotos->setQuery("SELECT fotos.fotosID, fotos.fotosNOM, fotos.fotosADD, fotos.fotosSUBCAT, fotos.fotosLARGOID, fotos.fotosCABID, fotos.fotosORD, largo.largoID, largo.largoDES, categoria.categoriaID, categoria.categoriaNOM, cabeza.cabezaID, cabeza.cabezaDES, subcategoria.subcatID, subcategoria.subcatNOM, subcategoria.subcatCATID FROM (((fotos LEFT JOIN largo ON fotos.fotosLARGOID = largo.largoID) LEFT JOIN cabeza ON fotos.fotosCABID = cabeza.cabezaID) LEFT JOIN subcategoria ON fotos.fotosSUBCAT = subcategoria.subcatID) LEFT JOIN categoria ON subcategoria.subcatCATID = categoria.categoriaID WHERE subcategoria.subcatID = ? ORDER BY fotos.fotosORD ASC");
$fotos->bindParam("i", "".($breadcrumbs->getColumnVal("subcatID")) ."", "-1"); //colname_1
$fotos->execute();
?>
<?php
while(!$breadcrumbs->atEnd()) {
?>
<div class="row">
<div class="col-md-12">
<div class="subcat-titulo">
<h4><?php echo($breadcrumbs->getColumnVal("subcatNOM")); ?></h4>
</div>
</div>
<?php
while(!$fotos->atEnd()) {
?>
<div class="col-sm-6 col-md-4">
<div class="thumbnail"> <img class="img-responsive center-block" src="media/gallery/<?php echo($fotos->getColumnVal("categoriaID")); ?>/<?php echo($fotos->getColumnVal("subcatID")); ?>/<?php echo($fotos->getColumnVal("fotosADD")); ?>" alt=""/>
<div class="caption caption_prod"><?php echo($fotos->getColumnVal("fotosNOM")); ?></div>
</div>
</div>
<?php
$fotos->moveNext();
}
$fotos->moveFirst(); //return RS to first record
?>
</div>
<?php
$breadcrumbs->moveNext();
}
$breadcrumbs->moveFirst(); //return RS to first record
?>
