como poder hacer menos while para poder mostrar categoria y sub categoria y sub sub categoria
Ejemplo
Código otro:
Ver originalCategoria
|_ 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
); }
$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>");
}
?>