how do you copy the whole field and pass it to another field

[redarrow]

Advance thank you.


I want to be able to let a user send another message to the database update them fields and copy the old info into another filed so that the old info can also be seen.

example

[code]
if (name || email || message ) {
query="update id,name,email,message from messages where name='$name' and email='$email'";
}

$query="insert into oldmessage (id,name,email,message)values('$name','$email','$message')";

[/code]

no session involved

So if a user posts a new message the database gets updated to message, and the oldmessage gets inserted to oldmessage.

Am i nearly there.