mysql_num_rows

mysql_num_rows returns the number of rows in a MariaDB result set; for unbuffered results the count is only accurate after all rows have been fetched.

Syntax

my_ulonglong mysql_num_rows(MYSQL_RES * );

Parameter

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

Description

Returns number of rows in a result set.

The behavior of mysql_num_rows() depends on whether buffered or unbuffered result sets are being used. For unbuffered result sets, mysql_num_rows() will not return the correct number of rows until all the rows in the result have been retrieved.

See Also

• mysql_affected_rows()

• mysql_use_result()

• mysql_store_result()

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