Hello Peeps

I'm trying to design a site where people can add stuff to a sql database, but before it's added to the db I want the administrator to validate the data, so this is what I think I should do but if any of you guys know better way to do this please let me know

I created two tables temporary table and the table which the validated data will be stored, so when punter comes along fills in a form and submits his story that goes to the temporary table and the admin gets an email telling him that there's a new entry that needs to be validated, the admin goes to the admin pages and validates the entry which either gets deleted or added to the permanent table, now I have one question for you that is if you are still with me <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle><img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

How can I create a form that will delete from the temporary tables and submit into the permanent tables when someone clicks onto submit

More Info
--------------------------------------------
ASP and Vb
IIS5 with SQL 2000
--------------------------------------------


Edited by - xlarge on 02 Aug 2002 17:55:55

I would just keep the one table and add another column called 'Visible' with two values 'Y" for yes and 'N' for no. I use MySql database and the column type is ENUM.

New submissions to your database could be automatically set to 'N' until the administrator reviews them. The administrator can then change the value to 'Y'.

To your queries just add WHERE visible=Y.