Delayed Table Alterations?

[Ning_Dynasty]

Howdy!

I'm going to have a login page for my site for users to edit portions of information I have stored in some mySQL tables. These tables are then compiled together and converted to flat files for distribution. I wanted to know how I could set it up where the user submits his alterations to the tables but I don't want them to take affect until an admin accepts these alterations. Would this be done using transactions? If so I guess I need to change all my tables to innoDB then right?

Thanks guys!

Brian

[wilku]

I haven't taken any courses in db creating, so my answer may not be the most appropriate.

I'd create another table that would store the changes untill they are accepted. For example if you have the final sql update query, you can store it in a text field in this table. Then you show this query to admin and if he accepts it, you run the stored query. Alternatively you can create your own "codes" of actions and store them (it's easeier to make an interpretation of what the query really does).