adding common

[lduong]

i currently have a table set up this way.

category ID / Parent ID/ Name

if a directory has no higher directory, it gets a 0 (zero) in the parent ID column and is autonumbered in the cat id column

If a directory has a parent directory, it gets the cat id# of that parent directory.

example:

school = parent 0, catid 1234
law school = parent 1234, cat id 5678
law school program = parent 5678, cat id 321

I want to be able to add a set of common "sub-sub" directories to each current subdirectory.

so for every subdirectory that is labeled "law school program" or "med school program", i need their to be sub-subdirectories that say "general", "supplemental", "miscellaneous"

so in the end, it would look like this:

>law school program
>general
>supplemental
>other

but i would want those subdirectories to be common for each program without having to manually type them all in.


you follow?

somebody please help, if you need futher explanation, i can send a piece of my table directly to you.