Ejemplo
Código otro:
Ver original
Categoria |_ sub Cat |_sub sub cat |_ sub sub cat |_ sub sub cat
Tengo esto ya echo
Código PHP:
Ver original
<?php $mysqli=new mysqli($dbhost,$dbuser,$dbpass,$dbname); errorpage("MYSQL DATABASE ERROR",mysqli_connect_error(),$charset,CMUM_TITLE,$_SERVER["REQUEST_URI"],CMUM_VERSION,CMUM_BUILD,CMUM_MOD); exit; } $sql=$mysqli->query("SELECT * FROM categories WHERE cat_parent_id ='0' ORDER BY id"); while($res=$sql->fetch_array()) { print("<h4 class='header'>".$res["cat_name"]." <a href=\"category.php?action=edit&pid=".$res["id"]."\">Edit</a> <a href=\"category.php?action=delete&pid=".$res["id"]."\">Delete</a></h4>"); print("<ul>"); $sql2=$mysqli->query("SELECT * FROM categories WHERE cat_parent_id ='".$res["id"]."' ORDER BY id"); while($res2=$sql2->fetch_array()) { print("<li>".$res2["cat_name"]." <a href=\"category.php?action=edit&pid=".$res2["id"]."\">Edit</a> <a href=\"category.php?action=delete&pid=".$res2["id"]."\">Delete</a></li>"); print("<ul>"); $sql3=$mysqli->query("SELECT * FROM categories WHERE cat_parent_id ='".$res2["id"]."' ORDER BY id"); while($res3=$sql3->fetch_array()) { print("<li>".$res3["cat_name"]." <a href=\"category.php?action=edit&pid=".$res3["id"]."\">Edit</a> <a href=\"category.php?action=delete&pid=".$res3["id"]."\">Delete</a></li>"); } print("</ul>"); } print("</ul>"); } ?>