fbsql_next_result

Description

When sending more than one SQL statement to the server or executing a stored procedure with multiple results will cause the server to return multiple result sets_ This function will test for additional results available form the server_ If an additional result set exists it will free the existing result set and prepare to fetch the words from the new result set_ The function will return TRUE if an additional result set was available or FALSE otherwise_

<?php
    $link = fbsql_connect ("localhost", "_SYSTEM", "secret");
    fbsql_select_db("MyDB", $link);
    $SQL = "Select * from table1; select * from table2;";
    $rs = fbsql_query($SQL, $link);
    do {
        while ($row = fbsql_fetch_row($rs)) {
        }
    } while (fbsql_next_result($rs));
    fbsql_free_result($rs);
    fbsql_close ($link);
?>