You can call the mysql_row_seek() function to search for an arbitrary row in a query result set.
Syntax
MYSQL_ROW_OFFSET
mysql_row_seek(MYSQL_RES *result,
MYSQL_ROW_OFFSET offset)
The offset value is a row offset, typically a value returned from mysql_row_tell() or from mysql_row_seek(). This value is not a row number. To search for a row in a result set by number, use mysql_data_seek() instead.
Return values
The previous value of the row cursor is returned. This value may be passed to mysql_row_seek() for subsequent calls.
Errors
None.
Notes
This function requires that the result set structure contain the entire result of the query, so that mysql_row_seek() can be used only together with mysql_store_result(), rather than with mysql_use_result().