AW: [PHP-DB] Archiving data in a database

¥eah, this was my first Idea, too, and I also use a "Delete"-Flag, but if you have an already coded project, you have to alter all SELECT- Statements like this: "SELECT * FROM Table WHERE Deleted = False AND ...." Greetinx, Mike (Germany) -----Ursprüngliche Nachricht----- Von: Chris Mason [mailto:chris@net.ai] Gesendet: Donnerstag, 23. November 2000 12:04 An: Sanders, Nicholas; php-db@lists. php. net (E-mail) Betreff: RE: [PHP-DB] Archiving data in a database How about havingng an "active" switch in a field, so you can switch off a staff member without purging the record. I rarely delete data, ususally I turn the record off. Chris Mason Box 340, The Valley, Anguilla, British West Indies Tel: 264 497 5670 Fax: 264 497 8463 USA Fax (561) 382-7771 Take a virtual tour of the island http://net.ai/ The Anguilla Guide Find out more about NetConcepts www.netconcepts.ai Talk to me in real time with Instant Messenger: masonc92@hotmail.com -----Original Message----- From: php-db-return-4684-chris=net.ai@lists.php.net [mailto:php-db-return-4684-chris=net.ai@lists.php.net]On Behalf Of Sanders, Nicholas Sent: Thursday, November 23, 2000 6:20 AM To: php-db@lists. php. net (E-mail) Subject: [PHP-DB] Archiving data in a database Hi, I'm designing a staff database and I've got about 20 tables some of them with 1 to many relationships i.e A member of staff can have multiple email addresses. What I'm trying to work out is what to do when I delete a member of staff I don't want to loose the data so how do I archive it. Should I create a replica of all the tables, or one table for each member of staff deleted? Any Ideas ? Cheers Nick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net