Db free result

db_free_result

Description:
Function db_free_result frees result memory allocated from db_query.
This function name starts with a lowercase letter.


Parameters:
(DBResult:dbresult)
int dbresult The result to free.


Return Values:
If DBResult:dbhandle is a valid handle, it returns 1, otherwise 0 if DBResult:dbhandle is a NULL reference.


Examples:
// Example function
GetNameBySpawnID(spawn_id)
{
	// Declare "p_name"
	new p_name[MAX_PLAYER_NAME+1];
 
	// Declare "query" and "db_result"
	static query[60], DBResult:db_result;
 
	// Formats "query"
	format(query, sizeof query, "SELECT `PlayerName` FROM `spawn_log` WHERE `ID`=%d", spawn_id);
 
	// Selects the player name by using "spawn_id"
	db_result = db_query(db_handle, query);
 
	// If there is any valid entry
	if(db_num_rows(db_result))
	{
		// Store data from "PlayerName" into "p_name"
		db_get_field(db_result, 0, p_name, sizeof p_name);
	}
 
	// Frees the result
	db_free_result(db_result);
 
	// Returns "p_name"
	return p_name;
}


Related Functions
The following functions may be useful, as they are related to this function in one way or another.