Re: [PHP-DB] Re: backup of database record before update

2007-11-01 Thread hochprior
Leo G. Divinagracia III wrote: Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious.

Re: [PHP-DB] Re: backup of database record before update

2007-11-01 Thread Neil Smith [MVP, Digital media]
At 09:46 01/11/2007, you wrote: Message-ID: [EMAIL PROTECTED] Date: Thu, 1 Nov 2007 10:45:57 +0100 Leo G. Divinagracia III wrote: Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion ... ...snip... ... on a 5.0.20nt box.

Re: [PHP-DB] Re: backup of database record before update

2007-11-01 Thread hochprior
Neil Smith [MVP, Digital media] wrote: At 09:46 01/11/2007, you wrote: Message-ID: [EMAIL PROTECTED] Date: Thu, 1 Nov 2007 10:45:57 +0100 Leo G. Divinagracia III wrote: Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion

Re: [PHP-DB] Re: backup of database record before update

2007-10-31 Thread Leo G. Divinagracia III
Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. i have used a couple simple

[PHP-DB] Re: backup of database record before update

2007-10-30 Thread Neil Smith [MVP, Digital media]
At 06:57 28/10/2007, you wrote: Message-ID: [EMAIL PROTECTED] Date: Sun, 28 Oct 2007 14:56:12 +0800 From: Ronald Wiplinger [EMAIL PROTECTED] I need some hints how to do that. Maybe there is a template or an easy function available. I have a MySQL database with some tables. Everytime a table

RE: [PHP-DB] Re: backup of database record before update

2007-10-30 Thread Stephen Sunderlin
media] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 3:16 PM To: php-db@lists.php.net Cc: Ronald Wiplinger Subject: [PHP-DB] Re: backup of database record before update At 06:57 28/10/2007, you wrote: Message-ID: [EMAIL PROTECTED] Date: Sun, 28 Oct 2007 14:56:12 +0800 From: Ronald

[PHP-DB] Re: backup of database record before update

2007-10-28 Thread hochprior
Ronald Wiplinger wrote: I need some hints how to do that. Maybe there is a template or an easy function available. I have a MySQL database with some tables. Everytime a table record changes, I want also put the old record to a history database. The history table and the original only differs