MySQL_GetResultSetCount

How many statements of the query read gave a result.

A query with several statements has a result for each. The first one is read until MySQL_SelectResultSet chooses another.

native MySQL_GetResultSetCount();

Remarks

A query holding several statements, with multi_statements on, or a stored procedure gives a set for each statement. The natives read the first one until another is selected.

Example

new MySQL:gDatabase;

stock PrintCounts() {
    new
        players,
        bans
    ;

    if (!MySQL_Run(gDatabase, "SELECT COUNT(*) AS total FROM players; SELECT COUNT(*) AS total FROM bans")) {
        return;
    }

    MySQL_GetValueInt(0, "total", players);
    MySQL_SelectResultSet(1);
    MySQL_GetValueInt(0, "total", bans);
    printf("%i players, %i bans", players, bans);
}

Related

• MySQL_SelectResultSet: Choose which statement of the query read the natives read.