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
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