Jump to content

copy 2 data fields from every row to a new table


systemsgotyou

Recommended Posts

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.