int mysql_next_result(MYSQL *mysql)
This function is used when you execute multiple statements specified as a single statement string.
mysql_next_result() the state of
the connection is as if you had called
mysql_query() for the next
statement. This means that you can call
mysql_affected_rows(), and so
an error, no other statements are executed and there are no more
results to fetch.
It is also possible to test whether there are more results by
However, this function does not change the connection state, so
if it returns true, you must still call
mysql_next_result() to advance
to the next result.
For an example that shows how to use
Section 17.6.15, “C API Support for Multiple Statement Execution”.
This function was added in MySQL 4.1.0.
|0||Successful and there are more results|
|-1||Successful and there are no more results|
|>0||An error occurred|
Commands were executed in an improper order. For example, if
you did not call
mysql_use_result() for a
previous result set.
The MySQL server has gone away.
The connection to the server was lost during the query.
An unknown error occurred.