MLM Hierarchical TreeView MySQL PHP [solved]

Multi-Level Marketing Members Hierarchical Tree View in MySQL and PHP for your references

MySQL Table Structure

create table mlm_members(id int auto_increment primary key, parentID int, member_name varchar(50))

PHP MLM Treeview Code Reference

<? include('config.php'); function display_children($parent, $level, $con) { $count = 0; $result = mysqli_query($con,'select id,parentID,mname from mlm_members where parentID="' . $parent . '"'); echo '<ul id="xul">'; while($row = mysqli_fetch_array($result)){ $var = $row["member_name"] . '<br>' . str_repeat(' ',$level).$row["id"] . '<br>'; echo $var; $count += display_children($row["id"],$level + 1,$con); } echo '</ul>'; } display_children(102,0,$con); ?>