put the data into variables, erase the record and then create a new one in the new table with the variable values!
"Dc" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all, > > I want to delete a record from my table 1, but would like all the data for > that single record passed onto my (archive) table 2 at the same time.... > Sounds easy!! > > Any ideas?? > > Thanks > > DC > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php