Modules/MTA-MySQL/mysql fields: Difference between revisions
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
|
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