View Single Post
 
Old March 14th, 2005, 03:57 AM
sherief sherief is offline
Authorized User
 
Join Date: Aug 2003
Location: Jakarta, DKI Jakarta, Indonesia.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sherief Send a message via Yahoo to sherief
Default

I think you need a temporary table which its fields just exactly like the real table and 1 field as your reference to real table, when users update it's stored in this temporary table, and when you approve, it updates the real table and deletes data on the temporary.

example:

tblUsers (the real one)
---------
record_id
name
address

tblUsersTemp (the temporary)
------------
record_id
users_id (reference to record_id in tblUsers)
name
address

Regards,
Sherief C. Mursyidi