mysql_use_result
Prev Function reference Next

mysql_use_result — Initiate an unbuffered result set retrieval

MYSQL_RES * mysql_use_result(MYSQL * mysql);

Used to initiate the retrieval of a result set from the last query executed using the mysql_real_query() function on the database connection. Either this or the mysql_store_result() function must be called before the results of a query can be retrieved, and one or the other must be called to prevent the next query on that database connection from failing.

Parameters

mysql

A mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Return value

Returns an unbuffered result set or NULL if an error occured.

[Note]

The mysql_use_result() function does not transfer the entire result set. Hence several functions like mysql_num_rows() or mysql_data_seek() cannot be used.

mysql_use_result() will block the current connection until all result sets are retrieved or result set was released bymysql_free_result().

See also

mysql_store_result(), mysql_free_result()

Prev Up Next
mysql_thread_safe Home mysql_warning_count