Db get field assoc


Function db_get_field_assoc get the contents of field with specified name.
Using an invalid handle will crash your server! Get a valid handle by using db_query. But it's protected against NULL references.
This function name starts with a lowercase letter.

(DBResult:dbresult, field[], result[], maxlength)
int dbresult The result to get the data from.
string field The fieldname to get the data from.
string result The result.
int maxlength The max length of the field.

Return Values:
Returns Bold text1 if successful, otherwise 0 if DBResult:dbresult is a NULL reference or the column index not available.

// Example function
	// Declare "p_name"
	new p_name[MAX_PLAYER_NAME+1];
	// Declare "query" and "db_result"
	static query[61], 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
		// Store data from "PlayerName" into "p_name"
		db_get_field_assoc(db_result, "PlayerName", p_name, sizeof p_name);
	// Frees the 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.