Hi all
I want to build a database for my wifes site for her bookmarks. I need it to support multiple catagories and infinate sub-catagories and am having a little trouble visualizing how this might be done.
So far I reckon to have one 'master table' containing
id|url|description|title
and a catagories table containg enums of all the catagories but that's where I'm stuck.
I'ts easy to build it if I limit it to one level of catagories but want if I want those to have catagories and so forth. (just like IE favourites)
I don't expect anyone to design for me but a few pointers would be great
Cheers
Nick
I want to build a database for my wifes site for her bookmarks. I need it to support multiple catagories and infinate sub-catagories and am having a little trouble visualizing how this might be done.
So far I reckon to have one 'master table' containing
id|url|description|title
and a catagories table containg enums of all the catagories but that's where I'm stuck.
I'ts easy to build it if I limit it to one level of catagories but want if I want those to have catagories and so forth. (just like IE favourites)
I don't expect anyone to design for me but a few pointers would be great
Cheers
Nick