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().