PDO - Multiply while statements with same variable

Question

I am currently in the process of learning PDO. I am trying to have multiply while statements, using the same variable. Now, when I used normal MySQL, I just used the mysql_data_seek(); function, in order to do this.

I have this code:

$r = $dbh->prepare("SELECT * FROM memberships ORDER by sort DESC");
$r->bindParam(':id', $userdata['membership']);
$r->execute();

<?php while($upgData = $r->fetch(PDO::FETCH_ASSOC)): ?>
 echo $upgData['id'];
<?php ?>

Then further down the code, I want to use it again:

<?php while($upgData = $r->fetch(PDO::FETCH_ASSOC)): ?>
 echo $upgData['name'];
<?php ?>

Although, the second time, nothing gets printed out. Why is that?

Pointer for fetch has reached the end of the Object. Reset it — Hanky Panky, Dec 01 '13 at 11:58
possible duplicate of [Reset cursor position in PDO](http://stackoverflow.com/questions/15111681/reset-cursor-position-in-pdo) — user4035, Dec 01 '13 at 12:01

score 1 · Accepted Answer · answered Dec 01 '13 at 12:01

Pointer for fetch has reached the end of the Object. Using MySQLi or MySQL extensions it was possible to reset this pointer to the first element but PDO doesn't seem to offer such functionality AFAIK. One way to go about is to first fetch all the values in an array.

$rows = $r->fetchAll();

Then iterate over that array two times

foreach ($rows as $r) {
    echo $r['name'];
}

foreach ($rows as $r) {
    echo $r['name'];
}

Using MySQLi or MySQL extensions it was possible to reset this pointer to the first element but PDO doesn't seem to offer such functionality AFAIK.

PDO - Multiply while statements with same variable

1 Answers1