Publish data from mySql when verified

[cyclic]

Hi

I have an application to upload data to a mySql database and a site to publish the data - pretty straight forward. What I want to do is have a user upload to the db and then I log on check that the input is ok and then allow it to be published on the site along with the rest of the records. How do I go about flagging these records so that it is ok for the script to publish on the site?

[coopster]

I think you just said it ;) Create a column that states whether or not the submission has been approved by you or not. If so, allow it to be displayed, if not, don't.

Another option: A separate, temporary storage file that upon approval writes the records to the permanent file and deletes the temporary entry.

[cyclic]

Thanks, I realised I just needed a simple WHERE statement in my query right after I pressed "submit"! Sunday morning....

[dmmh]

I do this another, perhaps more cumbersome way. I created tables to hold real content and similar tables for all yet unapproved content. When I review the entries and click 'deny', it gets deleted from the pending_ tables and when I press 'approve' its written to the real table :)

just another way