mariadb get assoc

Description

Get the specified row's association in a table with column name as the index.

Syntax

mariadb_get_assoc(row_idx)

Parameters

• row_idx
  The row index

Return Value

• Returns table with the column name as index

Example

function LoadVehicle()
    local query = mariadb_prepare(sql, "SELECT * FROM vehicles WHERE id = 1;")
    mariadb_async_query(sql, query, OnLoadVehicle)
end

function OnLoadVehicle()
    local result = mariadb_get_assoc(i) -- result is now a table with indexes of column name

    local id = tostring(result["id"]) -- This means that the result is basically a table, and the index is the column... pretty simple, right?
    local modelid = math.tointeger(result["modelid"])
end

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