PHP to reuse mysql result set rows

Question

I want to use a query result multiple times.

$result=mysql_query("Select field from tables;");

while($result_details = mysql_fetch_array($result))
  { echo $result_details[0]; //Returns 10 Rows..
}

but if I use mysql_fetch_array($result) again its not returning rows.. I don't want to execute the same query multiple times Please let me know how to use the results of a query multiple times.

Warning: The `mysql_xxx()` functions have been considered bad practice for a very long time, and are now formally deprecated. If at all possible, you should change your code to use the `mysqli_xx()` functions or the PDO library. — Spudley, Jan 20 '13 at 11:14
I suggest you read this: [Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) — Spudley, Jan 20 '13 at 14:55

score 2 · Answer 1 · edited Sep 04 '14 at 11:55

First fetch all records using a while loop:

$result=mysql_query("Select field from tables;");
while($result_details = mysql_fetch_array($result))
{
    $var[]=$result_details;
}

Then display all using a foreach loop and a single variable $var anywhere in the same page where you used query or put query in a functions.php file and include and use anywhere:

foreach ($var as $value) {
    $value['field'];
}

score 2 · Answer 2 · answered Feb 10 '17 at 06:37

If you do not want to make multiple queries then simply unwind the pointer to the desired position.After you execute your code.You should call function to seek to initial (0) position:

$result=mysql_query("Select field from tables;");

    while($result_details = mysql_fetch_array($result))
      { echo $result_details[0]; //Returns 10 Rows..
    }
        mysqli_data_seek($result ,0);

score 1 · Answer 3 · answered Jan 20 '13 at 10:50

1

You need to "rewind" result pointer using: http://php.net/manual/en/function.mysql-data-seek.php

answered Jan 20 '13 at 10:50

Marcin Orlowski

72,056
11
123
141

see this question: http://stackoverflow.com/questions/11621029/php-reset-mysqli-result – Jen-Ya Jan 20 '13 at 10:56
You meant to say ? mysql_free_result($result); – logan Jan 20 '13 at 10:59
1

No. I meant exactly what I wrote in my answer. `mysql_data_seek()`. If you free your result you'd not be able to do anything with it any more. – Marcin Orlowski Jan 20 '13 at 11:02

PHP to reuse mysql result set rows

3 Answers3