Trevor
|
| Posted: 01/31/2003, 5:32 PM |
|
I have been searching for this and cannot find a solution. The tell-a-friend example is not what I am trying to do unfortunately. Here it is:
I have a form that shows client data from a table. (MySQL) I want the client to be able to make changes to this data on the form but when the 'Update' button is clicked, I DON'T want the database to be updated but I want the form data to be sent to me via email to check before I manually update the database. So I guess there are two things I need...... firstly, how do I cancel an update and secondly, how do I email the form data? Any ideas?
|
|
|
 |
RonB
|
| Posted: 02/01/2003, 4:10 AM |
|
create a table that is exactly the same as the one you use now with the addition of a field where you store a 1 or a 2(1 hold, 2 ok). Pull the data from the original table. Do a custom insert of that information into the second table setting the value for the added field to 1.
In your administrtation page you can create the suff you need to do the revers. show unconfirmed updates. OK them and do a custum update to the original table and remove the entry from the second table.
Ron
|
|
|
|
|
