Automatically transferring data from one table to another

Hi, Is there a way I may transfer data from one table to another automatically? I have a table containing jokes which can be accessed thru a browser. I'm building another to which anyone can upload jokes. After reviewing them, I want to be able to transfer any I wish to keep automatically to

RE: Automatically transferring data from one table to another

I cannot allow to happen." HAL - 2001 (response to Dave) -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 30, 2000 1:18 PM To: [EMAIL PROTECTED] Subject: Automatically transferring data from one table to another Hi, Is there a way I may tr

Re: Automatically transferring data from one table to another

Hubert: I've found just setting an extra Yes/No column (called "Pending" in this example) in your main table. When a joke is submitted, it automatically sets "Pending" to Yes. Then, build a page that shows all of the items with Pending checked "Yes", and build it so all chosen id's get changed

Re: Automatically transferring data from one table to another

Eron Cohen wrote: Earl, Rather than have two tables, why not have a checkbox field in the database table labled "Approved". When you go to output your jokes, just make sure you have something like WHERE Approved=1, that way people viewing the site will only see your approved jokes.