PDA

View Full Version : Basic MySql design question


kobescoresagain
03-31-2006, 06:20 PM
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:

Paul M
03-31-2006, 06:51 PM
Just have a field in the main table called "confirmed" and set it to 0 or 1 to show the status of that entry.