Insert and delete at same time ?

barnfold

i have this statement at top of one of my files

$day = date(d);
$month = date(m);
$year = date(Y);

$del = "delete from message_post where EXday = \"$day\" and EXmonth = \"$month\" and EXyear = \"$year\" ";
$rdel = mysql_query($del) or die(mysql_error());

it deletes a posting on its expiration date.

What i want to try and do is IINSERT the data from the post to another table before its deleted and then DELETE it from the existing table as per the above command

Is it possible to just add an INSERT to the $del variable with an AND or something ??

thanks

Lars_Berg

Use 2 statements within a transaction

schematically

start transaction
insert into t2 select * from t1 where ...
if error then goto error:
delete from t1 where ...
if error then goto error:
commit
return
error:
rollback

barnfold

hello thanks for reply

what is a transaction i havnt seen it in the php or mysql manual (maybe im not looking hard enough) ??

colinhorne

Queries to use:

move = "update foo set bar = 'fong' where EXday = \"$day\" and EXmonth = \"$month\" and EXyear = \"$year\" ";

delete = "delete from message_post where EXday = \"$day\" and EXmonth = \"$month\" and EXyear = \"$year\" ";

Cheeers

Lars_Berg

Yes, you are not looking hard enough. Search at www.mysql.com for transactions.