PHP to reuse mysql result set rows [duplicate]

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
– Spudley, Commented Jan 20, 2013 at 11:14
I suggest you read this: Why shouldn't I use mysql_* functions in PHP? — Spudley
– Spudley, Commented Jan 20, 2013 at 14:55

Purushotam Sangroula · Accepted Answer · 2017-02-10 06:37:00Z

3

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);

answered Feb 10, 2017 at 6:37

Purushotam Sangroula

4951 gold badge11 silver badges29 bronze badges

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

Comments

julienc · Accepted Answer · 2014-09-04 11:55:43Z

2

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'];
}

edited Sep 4, 2014 at 11:55

julienc

20.4k19 gold badges87 silver badges86 bronze badges

answered Sep 4, 2014 at 11:33

Azim

394 bronze badges

Comments

Marcin Orlowski · Accepted Answer · 2013-01-20 10:50:31Z

1

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

answered Jan 20, 2013 at 10:50

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

3 Comments

Jen-Ya Over a year ago

see this question: stackoverflow.com/questions/11621029/php-reset-mysqli-result

logan Over a year ago

You meant to say ? mysql_free_result($result);

Marcin Orlowski Over a year ago

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.

Collectives™ on Stack Overflow

PHP to reuse mysql result set rows [duplicate]

3 Answers 3

Comments

Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Linked

Related