Db num fields

From SA-MP Wiki

Db num fields

Parameters:

new DBResult:result;
new string[128];
format(query,sizeof(query),"SELECT password,kills,deaths,level,score FROM `users` WHERE Username = '%s'", PlayerName[playerid]);
result = db_query(USERDB,query);;
format(string,sizeof(string),"You just seleted %d fields from the database", db_num_fields(result));
SendClientMessage(playerid,0xAFAFAFAA,string);
db_free_result(result);

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