(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
automatically generated byinfo2html