Name
mysql_data_seek( )
Synopsis
void mysql_data_seek(MYSQL_RES *result, my_ulonglong offset)
Use this in
conjunction with mysql_store_result( )
and a fetch
function such as mysql_fetch_row( )
to change the
current row being fetched to the one specified in the second argument
of this function.
... mysql_query(mysql, "SELECT client_id, client_name FROM clients ORDER BY start_date"); result = mysql_store_result(mysql); num_rows = mysql_num_rows(result); mysql_data_seek(result, (num_rows - 8)); while((row = mysql_fetch_row(result)) != NULL) { printf("%s (%s) \n", row[1], row[0]); } ...
This program excerpt retrieves a list of client names along with
their respective IDs. Using the mysql_data_seek( )
function in conjunction with mysql_fetch_row( )
and a while
statement, the last eight clients who
started with the company will be displayed.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.