I am running an online form that is supposed to post data into the database. My database is oracle backend but I would assume any database will do e.g. access, oracle or mysql. I want all the data collected on this form to be approved before it is posted to my database. Meaning that user will fill in the form and submit it to me, when I review it and oks it I will click on approve button and data will be entered into the database. Also I want the user to recive a html page or information letting him or her know that the form was submitted as soon as the click submit button but he or she cannot know it is going to be approved or rejected that will be internal thing we do to control the data in the database. So how can I collect this information, approve the data and post it on the database? I know collecting data into the database is easy but the approval process is confusing for me. Help!!!

wambui what language are you using? PHP, perl, asp?
-dk

DK I am using oracle as my backend and web browser or HTML as my front end. So I was thinking of Php, or asp. I could create a table an post users entry and then transfer it into database. I have done it with VB but I had to install the VB script into the client computer but this client want it to operate on the server so vb will not work here. ASP needs PWS. so php will definitely be the one needed in this or how about writing a pl/sql script to execute it? Help!!

make 2 tables within your database, approved ones and non approved ones. Then the data is posted to the non approved database, then you have a page where you can read all of the non approved ones, then make it so you approve em and they are posted on the approved database and erased from the non appr. one. Use PHP.

I would suggest using php because it has many oracle function built in to make it easy to use an oracle db. However, like asp, php is server-side so you will have to install it on your web server. What webserver do you have set up? Apache, iis?
-dk

I will go for 2 tables and I will use PHP. I believe the web server is Apache. Thanks Mo money and DK1.
Peace .

If you haven't set it up yet, you might want to consider keeping to one table but adding a field for 'approved'.

That way you only have to have one table but you can still query it only getting the approved data (i.e. WHEN approved=1)