Move Data from 1 Table to Another
I have a PHP script that retrieves information from a table in a database and I have a PHP script that adds data to a table. What I'm after is some way to put the data I retrieve from 1 table into another table. Is there a MYSQL command to move data from one table to another? Or should I be going about this a different way?
I did think that maybe I could get the data retrieved to be stored in a form maybe. And then if I click submit, it would send the data to the existing 2nd table.
Any ideas would be helpful.