Hello I'm writing PHP and mysql. If I want to select then insert to database, I will
If you want to do this via mysql you can use
INSERT INTO Table2(field1, field2) SELECT old_field1 as field1, old_field2 as field2 FROM Table1
Just be sure that you match fieldnames with "as".