How do I make a tree view from MySQL and PHP

[projectdeploy]

I have an application in the making that needs to show a treeview of files and directories.

 

I have it all working based on an <ul>. Each <li> is a sub file .

 

I have a table set up with:

name, parent, type, user, content, project, date, id

 

I set up the DB to set the parent as the id of it's parent (e.g. Directory "A" has an id of "2" and parent of "0" and directory "B" has an id of "20" and a parent of "2". B would be nested inside of A because it's parent matches it's id).

 

Here is a sample of what I want the markup to be like:

 

<ul>
<li class="folder">
	The Project Name
	<ul>
		<li class="folder">
			css
			<ul>
				<li class="file">style.css</li>
				<li class="file">thickbox.js</li>
			</ul>
		</li>
		<li class="folder">
			includes
			<ul>
				<li class="folder">
					functions
					<ul>
						<li class="file">math.php</li>
						<li class="file">mysql_connect.php</li>
					</ul>
				</li>
				<li class="file">header.php</li>
				<li class="file">sidebar.php</li>
				<li class="file">footer.php</li>
			</ul>
		</li>
	</ul>
</li>
</ul>

I can not figure this out. Does anyone know how to sort recursively like this?!

[GingerRobot]

You may wish to read this article on storing hierarchical data:

 

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html