prepare("SELECT id, descrip FROM categ_clasif WHERE agrupar_en_prod = '1' ORDER BY descrip"); $stmt->execute(); $stmt->bind_result($clasif_id, $clasif_descrip); $clasificaciones = []; while ($stmt->fetch()) { $clasificaciones[] = ['id' => $clasif_id, 'descrip' => $clasif_descrip]; } $stmt->close(); foreach ($clasificaciones as $row_categclasif) { $stmt2 = $con1->prepare("SELECT c.id_categoria, c.descripcion FROM categ_categclasif cc JOIN categoria c ON c.id_categoria = cc.id_categ WHERE cc.id_categclasif = ? ORDER BY c.descripcion"); $stmt2->bind_param("s", $row_categclasif["id"]); $stmt2->execute(); $stmt2->bind_result($cat_id, $cat_desc); $categorias_hijas = []; while ($stmt2->fetch()) { $categorias_hijas[] = ['id_categ' => $cat_id, 'descripcion' => $cat_desc]; $arreglo_agrupadas[] = $cat_id; } $stmt2->close(); if (count($categorias_hijas) > 0) { ?> prepare("SELECT id_categoria, descripcion FROM categoria ORDER BY descripcion"); $stmt3->execute(); $stmt3->bind_result($cat_id2, $cat_desc2); while ($stmt3->fetch()) { if (!in_array($cat_id2, $arreglo_agrupadas)) { ?> close(); ?>

Categoría Principal / Subcategoría	Acciones
	#" class="action-link" title="Editar"> #" class="action-link" title="Eliminar">
Otras Categorías
	#" class="action-link" title="Editar"> #" class="action-link" title="Eliminar">