多次运行while（$ row = sqlsrv_fetch_array（$ result））

Question

I am retrieving a couple of tables from a MSSQL database, which I am then running through to obtain order information from.

My code looks like this:

    while($row = sqlsrv_fetch_array($orderResult))
    {
        ......code........
        ..................
        while($statusRow = sqlsrv_fetch_array($statusResult))
        {
            ....code....
        }
        ....code....
    }

Now my problem is that after the second loop runs through, it never runs again. And I need it to run every time the first loop runs.

Is there anything I can do to reset that second loop to run again?

Thank you in advance. Any help or a push in the right direction will be very helpful.

Answer 1

Read about the other parameters in sqlsrv_fetch_array()

You can do something like this to reset

// reset, and get first row
$row = sqlsrv_fetch_row($result, SQLSRV_FETCH_BOTH, SQLSRV_SCROLL_FIRST);

// get second (and nth row) normally
$row = sqlsrv_fetch_row($result);

Alternatively, I think you could benefit from doing a JOIN in your query to return a single result. Merging results manually like this seems a little hackish.