Fetch array multiple times in PHP.

See more:

SQL-Server

PHP

Hello,

I need to loop over $result more than once, yet I can only call sqlsrv_fetch_array($result) once. If I try to use it again in the script, I get nothing. Here is an example:

$result = sqlsrv_query($conn,$query,$sql_params,SQLSRV_CURSOR_FORWARD);

while ($row = sqlsrv_fetch_array($result)) {
   while ($arow = sqlsrv_fetch_array ($aresult)) {
        echo $arow[foo];
   }
}

I used sqlsrv_fetch($aresult, SQLSRV_SCROLL_FIRST) to set cursor, but don't right. If I try $query is SELECT query, it's OK.

What are you supposed to do when you need to loop over your database query results multiple times ?