Db free-result

From SA-MP Wiki

Db free-result

Parameters:

public OnPlayerText(playerid, text[])
{
        new query[256];
        format(query, sizeof(query), "INSERT INTO chat VALUES ('%d','%s')",playerid,text);
        db_free_result(db_query(CHATDB,query));
        //Note this is a really bad idea to use this code, as it would be easy to inject SQL code into.
        return 1;
}

Related Functions

The following functions might be useful as well, as they're related to this function in one way or another.

• db_open: Open an SQLite database

• db_close: Close an SQLite database

• db_query: Query an SQLite database

• db_free-result: Free result memory from a query

• db_num_rows: Get number of rows in result

• db_next_row: Move to the next row

• db_num_fields: Get number of fields in result

• db_field_name: Returns the name of a particular field

• db_get_field: Get content of field with specified ID from current result row

• db_get_field_assoc: Get content of field with specified name from current result row