Basic MySql design question
 

As part of my Sports Card and autograph trading site I want to have a listing of addresses which you can use to obtain autographs through the mail. I want this to be editable by all members of my site. But I also want to make sure that nothing is updated without my approval. My idea was to make a temporary table that is identical to the table with the information that they want to update. Then store the information into this table until I confirm it. Does this sound like the best way to do it, or is there a better way?

Thanks ahead of time:banana: :banana:

Just have a field in the main table called "confirmed" and set it to 0 or 1 to show the status of that entry.