Hi guys, I'm having a spot of bother working out how to delete a 'folder' in a tree database.
Problem is that I need to delete all 'sub-folders' and their contents and I just can't see how to do it if I dan't know how many (if any) sub-folders a folder may have?
Here's how the database is set up
Bookmarks DB
urls
id|name|location|desc
catagories
cat_id|parent|name
cat_link
id|url_id|cat_id
Hope someone can point me in the right direction.
Nick
Problem is that I need to delete all 'sub-folders' and their contents and I just can't see how to do it if I dan't know how many (if any) sub-folders a folder may have?
Here's how the database is set up
Bookmarks DB
urls
id|name|location|desc
catagories
cat_id|parent|name
cat_link
id|url_id|cat_id
Hope someone can point me in the right direction.
Nick