(mysql.info.gz) mysql_next_result

Info Catalog

(mysql.info.gz) mysql_more_results

(mysql.info.gz) C API functions

 
 22.2.3.66 `mysql_next_result()'
 ...............................
 
 `int mysql_next_result(MYSQL *mysql)'
 
 Description
 ...........
 
 If more query results exist, `mysql_next_result()' reads the next query
 results and returns the status back to application.
 
 You must call `mysql_free_result()' for the preceding query if it
 returned a result set.
 
 After calling `mysql_next_result()' the state of the connection is as
 if you had called `mysql_real_query()' or `mysql_query()' for the next
 query.  This means that you can call `mysql_store_result()',
 `mysql_warning_count()', `mysql_affected_rows()', and so forth.
 
 If `mysql_next_result()' returns an error, no other statements will be
 executed and there are no more results to fetch.
 
  C API multiple queries.
 
 This function was added in MySQL 4.1.0.
 
 Return Values
 .............
 
 *Return Value*         *Description*
 0                      Successful and there are more results
 -1                     Successful and there are no more results
 >0                     An error occurred
 
 Errors
 ......
 
 `CR_COMMANDS_OUT_OF_SYNC'
      Commands were executed in an improper order. For example if you
      didn't call `mysql_use_result()' for a previous result set.
 
 `CR_SERVER_GONE_ERROR'
      The MySQL server has gone away.
 
 `CR_SERVER_LOST'
      The connection to the server was lost during the query.
 
 `CR_UNKNOWN_ERROR'
      An unknown error occurred.
 

Info Catalog

(mysql.info.gz) mysql_more_results

(mysql.info.gz) C API functions