Re: Changing Fields

Just add hidden fields on the update page called: <fieldname>_orig or something to that effect. Then on the backend see if <fieldname> != <fieldname>_orig This is one method at least.... Bob Silva Lead Developer Bravenet Web Services www.bravenet.com ----- Original Message ----- From: "Mark McCray" <mm@tbwachiat.com> To: <php-db@lists.php.net> Sent: Thursday, September 07, 2000 10:55 AM Subject: [PHP-DB] Changing Fields > Hey there, > I need to know how to do someting. > I've written an employee database. One of the things I want employees to do > is to be able to update their information as it changes (address, last name, > ss# or whatever). On the record editing page, all the fields that they are > allowed to modify are there. When I update the record, all fields are > updated. Most of the time they 're updating only a couple of fields. I > want to be able to send an email to our HR department and notify them only > about the fields that have changed. Since all the fields are actually in > the update statement, how would I be able to tell what information had > changed and what had not? > Thanks, > Marky > > > -- > 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 > >