[PHP-DB] Re: exporting data to excel

2004-03-24 Thread Geir Pedersen - Activio AS
Matthew, I am looking for the easiest way to export data to an excel file. Is the eaiest way to use PHP's file handling functions? I assume you want to delivery the execl file to a web user. Then there is no need to write the data to disk, you can generate the whole thing on the fly while you

[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.