mysql_fetch_row

mysql_fetch_row retrieves the next row from a MariaDB result set as an array of char pointers, returning NULL when no more rows are available.

Syntax

MYSQL_ROW mysql_fetch_row(MYSQL_RES * result);

Parameter

• result - a result set identifier returned by mysql_store_result() or mysql_use_result().

Description

Fetches one row of data from the result set and returns it as an array of char pointers (MYSQL_ROW), where each column is stored in an offset starting from 0 (zero). Each subsequent call to this function will return the next row within the result set, or NULL if there are no more rows.

If a column contains a NULL value the corresponding char pointer will be set to NULL.

Memory associated to MYSQL_ROW will be freed when calling mysql_free_result() function.

See Also

• mysql_use_result()

• mysql_store_result()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}