[PHP-DB] Re: Recursive photo gallery removal problem.

2004-03-26 Thread Tom Reed
No solutions or feedback? :( -Tom Reed [EMAIL PROTECTED] Tom Reed [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I designed a photo gallery system, in which I allow users to create recursive photo folders. The trouble I am having is being able to delete a photo folder, and all

Re: [PHP-DB] Re: Recursive photo gallery removal problem.

2004-03-26 Thread jeffrey_n_Dyke
No solutions or feedback? :( -Tom Reed [EMAIL PROTECTED] _ How do you select _all_ the images from Folder B? Can you show that statement? In every delete you're able to do against a database table, you should first be able to run a select and basically replace

[PHP-DB] Re: Recursive photo gallery removal problem

2004-03-26 Thread Geir Pedersen - Activio AS
Tom, I understand you have a structure of folders, each with a single parent folder. You want to be able to delete one specific folder and then have all folders directly or indirectly under that folder removed at the same time. This is easy to do using a foreign key with an on delete clause.