PHP ADODB - Reuse Query Result

[mcfc4heatons]

I'm working on a PHP ADODB Project and want to reuse a query result and loop through results again, at the moment I am using the following approach, but assume this is inefficient and there must be a better approach?:

$query = "SELECT colname FROM table";
$result1 = $db->SelectLimit($query,10,-1);
$result2 = $db->SelectLimit($query,10,-1);

// 1ST RUN
while (!$result1->EOF) {
echo $result1->Fields('colname').'<br>';
$result1->MoveNext();
}
// 2ND RUN
while (!$result2->EOF) {
echo $result2->Fields('colname').'<br>';
$result2->MoveNext();
}

 

[kicken]

You could just read the results into an array, then use that for your two loops.

$query = "SELECT colname FROM table";
$result1 = $db->SelectLimit($query,10,-1);
$resultData=[];
while (!$result1->EOF) {
    $resultData[]=$result1->Fields('colname');
    $result1->MoveNext();
}

// 1ST RUN
foreach ($resultData as $colname){
    echo $colname.'<br>';
}

// 2ND RUN
foreach ($resultData as $colname){
    echo $colname.'<br>';
}

 

[Barand]

mysqli has a fetch_all() method and PDO has a fetchAll() method.

Both of the above would create that array for you.

Does ADODB have the equivalent?