CMS delete 1st level page removes second level page

Hi,

I am devleoping a CMS system and would like to know a solution to this problem I have.

I am able to create 1st level pages. I am also able to create 2nd level pages and assign them to the 1st level page....

My issue is that when a client deletes a 1st level page, I would like all of the 2nd level pages associated with the 1st level page to also be removed...

Thanks

When you assign the second level page to the first level page, you are most likely using the Parent page ID, so each child page will have a column in which that parent ID is stored.

When you delete the parent page, you will have to pass the parent id, say the parent id is 4:
DELETE FROM parentTable WHERE ID = 4


you pass that same id when delting from the child table:
DELETE FROM childTable WHERE parentID = 4

Thanks Jason

I will give that a go!

Originally Said By: simmo515303621

  Thanks Jason

I will give that a go!  

Did it work? I would like to do the same so it would help to know if it worked. Thanks.

The original poster did not post back their results, so I can only assume that they where able to get it to work.

If you try and are having problems getting it to work, let us know and we will be glad to help.