mariadb get value index: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
{{FuncParameters}} | {{FuncParameters}} | ||
{{FuncParam|row_idx|The row index (starts at 1)}} | {{FuncParam|row_idx|The row index (starts at 1)}} | ||
{{FuncParam|column_idx|The column | {{FuncParam|column_idx|The column name}} | ||
{{FuncReturnValue|Returns the value on '''success''', '''false''' on error.}} | {{FuncReturnValue|Returns the value on '''success''', '''false''' on error.}} | ||
| Line 14: | Line 14: | ||
== Example == | == Example == | ||
<syntaxhighlight lang="Lua> | <syntaxhighlight lang="Lua> | ||
local | local player_name = cache_get_value_name_int(1, "name"); | ||
AddPlayerChat(playerid, "The value in the first row and in the column | AddPlayerChat(playerid, "The value in the first row and in the column 'name' is "..player_name); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
{{RelatedFunctions}} | {{RelatedFunctions}} | ||
{{Template:MariaDBFunctions}} | {{Template:MariaDBFunctions}} | ||
Latest revision as of 13:52, 20 November 2019
Description
Retrieves a value from the result set as a string.
Syntax
mariadb_get_value_index(row_idx, column_idx)
Parameters
- row_idx
The row index (starts at 1) - column_idx
The column name
Return Value
- Returns the value on success, false on error.
Example
local player_name = cache_get_value_name_int(1, "name");
AddPlayerChat(playerid, "The value in the first row and in the column 'name' is "..player_name);
See also
- OnQueryError
- mariadb_log
- mariadb_connect
- mariadb_connect_file
- mariadb_close
- mariadb_unprocessed_queries
- mariadb_async_query
- mariadb_query
- mariadb_await_query
- mariadb_query_file
- mariadb_await_query_file
- mariadb_errno
- mariadb_error
- mariadb_escape_string
- mariadb_prepare
- mariadb_set_charset
- mariadb_get_charset
- mariadb_stat
- mariadb_get_row_count
- mariadb_get_field_count
- mariadb_get_result_count
- mariadb_get_field_name
- mariadb_set_result
- mariadb_get_value_index
- mariadb_get_value_index_int
- mariadb_get_value_index_float
- mariadb_get_value_name
- mariadb_get_value_name_int
- mariadb_get_value_name_float
- mariadb_save_result
- mariadb_delete_result
- mariadb_set_active_result
- mariadb_unset_active_result
- mariadb_is_any_result_active
- mariadb_is_valid_result
- mariadb_get_affected_rows
- mariadb_get_warning_count
- mariadb_get_insert_id
- mariadb_get_query_exec_time
- mariadb_get_query_string
- mariadb_get_row
- mariadb_get_assoc
