Reset row pointer of a mySQL result (PDO) [duplicate]

Question

I need to loop through the results of a query a few times. After the first loop, I cannot go through the results again as the pointer is at the bottom. How can I make it return to the top? I dont want to run the query again as that is just going to use up more resources and return the same results.

$stmt = $conn->prepare("SELECT * FROM customers"); $stmt->setFetchMode(PDO::FETCH_ASSOC); $stmt->execute(); //This kind of loop will repeat elsewhere in the code while($row = $stmt->fetch()){ //Do something here }

AbraCadaver · Accepted Answer · 2013-10-11 21:08:32Z

2

while($row = $stmt->fetch()){ $rows[] = $row; //use $rows later //Do something here with $row }

answered Oct 11, 2013 at 21:08

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

AbraCadaver Over a year ago

Just saw duplicate. Just use $rows = $stmt->fetchAll();

Collectives™ on Stack Overflow

Reset row pointer of a mySQL result (PDO) [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related