[eluser]Ryuuzaki92[/eluser]
hi, i'm creating a movie database site where members can submit or edit the movies. before the user can see the result, a mod has to approve it. so i was wondering, what is the best way to implement this? i was thinking of having 2 tables, one is the movies table and the other is the submissions table. when a member submit the form, it will serialize the $_POST and dump it into the submissions table. i was thinking of adding a 'is_approved' column in the movies table but i do not want to pollute the table with dupes (ugly IDs) and it doesn't work with edits. i'm planning to do the same for characters and actors as well.
is there any other better way to achieve this? thanks!
