慎用PHP的fetchAll()方法

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