$result = $adapter->query("SELECT * FROM tablename ...");
foreach ($result->fetchAll() as $row) {
//
}
/****************************************************************/
while($row = $result->fetch()){
//
}
$result = $adapter->query("SELECT * FROM tablename ...");
foreach ($result->fetchAll() as $row) {
//
}
/****************************************************************/
while($row = $result->fetch()){
//
}