mysql_stmt_row_seek()

mysql_stmt_row_seek() searches for an arbitrary row in the result set of a prepared statement.

Syntax

MYSQL_ROW_OFFSET
mysql_stmt_row_seek(MYSQL_STMT *stmt,
                    MYSQL_ROW_OFFSET offset)

The value of offset indicates the row offset that is returned by mysql_stmt_row_tell() or mysql_stmt_row_seek().

Return values

The previous value of the row cursor. The value can be used to call mysql_stmt_row_seek().

Error messages

None.

Notes

The value of offset is not a row number. If you want to find a row in the result set by number, use mysql_stmt_data_seek().

This function requires that the result set structure contains the entire result of the query. Therefore, you need to use mysql_stmt_row_seek() with mysql_stmt_store_result().