How to reset mysqli_result to the beginning? [duplicate]

Question

I have the following piece of code that I am having problems resetting the $row array. It's a nested loop, $row works the first time, then is blank on additional loops.

/**Setup local variables with passed data**/
$ing = $this->getVariable('ingredients');
$row = $this->getVariable('unitdrop');
$unit= $this->getVariable('unit');

/**Start Displaying data**/
if (!$ing) {print("No ing");}
else
{while ($i = $ing->fetch_array())
{
/**Display $ing Data**/
    if (!$row) {print("No data row");}
    else
    {while($p = $row->fetch_array())
        {
        /**Display $row Data**/
        } 
    }
reset($row); // <-- Does not reset $row to first record
}

Just checking that you're closing your block comments /* Display $row data */ — Jamie
– Jamie, Commented Jul 23, 2012 at 21:49
Does $row return the same data with every loop? Why not iterate it once and store inside an array? — mellamokb
– mellamokb, Commented Jul 23, 2012 at 21:49
@Jamie - Yes the block comment should be closed, my code is different, I am using this as an example, can't share the actual code. — David
– David, Commented Jul 24, 2012 at 0:25
@mellamokb - Yes $row does return the same data each time. Thanks for the suggestion, I'll give it a shot. — David
– David, Commented Jul 24, 2012 at 0:36
@mellamokb - I appreciate the suggestion. However I find that option to be more coding then it's worth. Is there not a way to either reset the $row object or return it to the first record rather then creating a multidimensional array? — David
– David, Commented Jul 24, 2012 at 5:39

Jan Turoň · Accepted Answer · 2012-07-24 07:08:30Z

6

reset resets an array. $row is an object of class mysqli in your case. Use the method mysqli::data_seek instead (see the example in the link). Should be $row->data_seek(0); I guess.

edited Jul 24, 2012 at 7:08

answered Jul 23, 2012 at 21:51

Jan Turoň

33.2k24 gold badges139 silver badges179 bronze badges

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

1 Comment

David Over a year ago

Thank you, Thank you, Thank you!!! I spent hours last night reading and trying different combinations of reset, unset, close, mysql_data_seek and was going to embark on reprogramming hundreds of lines to change the way my app works.... $row->data_seek(0) worked like a charm! Thank you.

Collectives™ on Stack Overflow

How to reset mysqli_result to the beginning? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related