   #PHP Manual FrontBase Functions fbsql_list_tables fbsql_num_fields

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               fbsql_next_result

   (PHP 4 >= 4.0.6)
   fbsql_next_result --  Move the internal result pointer to the next
   result

Description

   bool fbsql_next_result ( resource result_id)

   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.

   Example 1. fbsql_next_result() example
   <?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);
   ?>
   ______________________________________________________________________

   Prev              Home             Next
   fbsql_list_tables  Up  fbsql_num_fields
