I need to find a function or method that will reset or seek the dataset handle back to the beginning so I can fetchrow all over again without doing execute() functions all the time...
[code] $dbConnection->{FetchHashKeyName} = "NAME_lc"; $dataGrid = $dbConnection->prepare("SELECT field, type FROM list"); $dataGrid->execute(); for($i=0; $i<3; $i++){ while ($fieldRow = $dataGrid->fetchrow_hashref()) { print $fieldRow->{'field'}; } #Nee to seek back to first row in $dataGrid here; $dataGrid->seekBackToFirstRow(); #I need a function to do it here... #fails because no such method exists to do above } $dataGrid->finish(); [/code]