Modules/MTA-MySQL/mysql fields: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
(New page: __NOTOC__ Creates an iterator for the result fields. When this function is called, the field cursor is set to the first field. ==Syntax== <syntaxhighlight lang="lua"> iterator mysql_fields ( MySQLResult...)
 
m (Oh god, not again.)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
__NOTOC__
__NOTOC__
{{ModuleFunction|MTA-MySQL}}
Creates an iterator for the result fields. When this function is called, the field cursor is set to the first field.
Creates an iterator for the result fields. When this function is called, the field cursor is set to the first field.


Line 27: Line 29:
   end
   end
end
end
mysql_free_result(result) -- Free the result
</syntaxhighlight>
</syntaxhighlight>


==See also==
==See also==
{{Modules/MTA-MySQL/Result_functions}}
{{Modules/MTA-MySQL/Result_functions}}

Latest revision as of 18:03, 5 January 2011


Package-x-generic.png This function is provided by the external module MTA-MySQL. You must install this module to use this function.

Creates an iterator for the result fields. When this function is called, the field cursor is set to the first field.

Syntax

iterator mysql_fields ( MySQLResult result )

Required arguments

  • result: A valid MySQL result

Returns

An iterator function to iterate all the result fields.

Example

Example 1: This example shows how to print the rows of a result set showing the field name.

local result = mysql_query(handler, "SELECT * FROM account") -- Execute the query
for result,row in mysql_rows(result) do -- Iterate through all the result rows
  local i = 1
  for result,field in mysql_fields(result) do
    if (row[i] ~= mysql_null()) then
      outputDebugString("row[" .. field["name"] .. "] = " .. row[i])
    else
      outputDebugString("row[" .. field["name"] .. "] = NULL")
    end
    i = i + 1
  end
end
mysql_free_result(result) -- Free the result

See also