So confused with PDO while loop

[systemsgotyou]

Hello. I am new. I have simple two step process I want to be done. When it does work the webpage keeps going (im guessing it's an endless loop)... I can't seem to get it to work: I know there's something I'm missing about this PDO array stuff.

<?php

include("database.php");
$time_ago = strtotime("-1 minute");


/*find subscribers over a month old with the thirtydaysubs table*/

$checker = "SELECT emailaddress FROM aa_thirtydaysubs WHERE subscribedate < $time_ago";
$sthandler = $database->prepare($checker);
$sthandler->execute();


/*then move it to main list and remove from 30 day list*/

$data = array();
$data = $sthandler->fetch();


if ($sthandler->columnCount()){
while($sthandler->fetchAll(PDO::FETCH_ASSOC) !== 0){

$email2 = $data->fetchColumn(0);

$newlist= "2";
$updatelistid = "UPDATE zzemail_list_subscribers set listid = :newlist WHERE emailaddress = :email";
$sthandler3 = $database->prepare($updatelistid);
$sthandler3->execute(array(':email' => $email2, ':newlist' => $newlist ));



$clearars = "DELETE FROM aa_thirtydaysubs WHERE	emailaddress= :email";
$sthandler6 = $database->prepare($clearars);
$sthandler6->execute(array(':email' => $email2));
}
}
?>

[Ch0cu3r]

fetchAll returns an array of results. You'll want to use a foreach loop instead

foreach($sthandler->fetchAll(PDO::FETCH_ASSOC) as $data){

$email2 = $data['emailaddress'];

$newlist= "2";
$updatelistid = "UPDATE zzemail_list_subscribers set listid = :newlist WHERE emailaddress = :email";
$sthandler3 = $database->prepare($updatelistid);
$sthandler3->execute(array(':email' => $email2, ':newlist' => $newlist ));



$clearars = "DELETE FROM aa_thirtydaysubs WHERE	emailaddress= :email";
$sthandler6 = $database->prepare($clearars);
$sthandler6->execute(array(':email' => $email2));
}

If you used the fetch method then you'd use a while loop.

Edited January 9, 2014 by Ch0cu3r

[systemsgotyou]

You are a godsend! So I keep the

$data = array();
$data = $sthandler->fetch();

Right?

[Ch0cu3r]

You are a godsend! So I keep the

$data = array();
$data = $sthandler->fetch();

Right?

No, If you are using fetchAll then remove those lines.

[systemsgotyou]

Ok thanks dude! I owe you one!