copy 2 data fields from every row to a new table

[systemsgotyou]

I am trying to copy two pieces of info from a table into a new table. I know if I wanted to do one piece of data it would look like this:

$getemaipips = "SELECT emailaddress FROM zzemail_list_subscribers LIMIT 1";
$getemaipips_rst = $database->prepare($getemaipips);
$getemaipips_rst ->execute();



/*
 * 
 */
foreach ($getemaipips_rst->fetchAll(PDO::FETCH_ASSOC) as $data) {
    $email  = $data['emailaddress'];
    $newlistid = $twentyfivedaylistid;

But if I wanted to do that for TWO fields how would it look? Can I do a select AND command?

[systemsgotyou]

never mind got it!

 

use a comman between field!

[Barand]

Single query

INSERT INTO table2 (colA, colB) SELECT col1, col2 FROM table1