Modified Preorder Tree Traversal
 

grrrrr.....trying to work with hierarchical data is kicking my ass...I want to just do a simple directory site in mysql with categories such as this:

top/free
top/free/a
top/free/b
.
.
.
top/amatuer
.
.
etc

I'm thinking the easiest way is just to put the path info into the database plus all the children categories...for example, for

top/free

I would include a field that would contain the children:

a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y, z

any pointers? tia