Hello All,
I have a data table with the columns firstname, lastname and rank. I am moving those values from that table into an archive table and the archive table has the same structure, but an additional date on the end. Obviously to tell the different between the repeating values.
I have a query like this......
$insert = "INSERT INTO archive (firstname, lastname, rank) VALUES (SELECT firstname, lastname, era FROM old)";
How can I add the mysql command CURDATE() into that insert command? Can I add parentheses inside of the parentheses around the SELECT command??
Thanks in advance??