insert into new table and delete from old

[rikmoncur]

I've got 2 tables of users: 'pending' and 'approved'.

The first table (pending) is a 'holding' table for unapproved users and when the user is approved I can click on a checkbox by their name and copy them over to the approved users table (INSERT INTO approved...)

This all works fine but I'd also like to delete them from the 'pending' table at the same time. How would I do this? Something like (INSERT INTO approved, DELETE FROM pending)?

I'd do a bit of trial and error but since it's on a live site, I don't want to muck it up and not be able to fix it!

I thought I'd ask to see if there was a quick and simple answer before launching into a whole new test site...

thanx if you can help!

[devinemke]

don't do 2 tables, just use 1. just add a new boolean field to the table called "approved". when a new user is entered leaved the field to FALSE. if you want to approve them update the field to TRUE, if not than just delete the record (or leave it FALSE if you want to have an archive of unapproved users).