Modules/MTA-MySQL/mysql fields - Revision history

Alberto Alonso: Oh god, not again.

2011-01-05T18:03:42Z

Oh god, not again.

← Older revision		Revision as of 18:03, 5 January 2011
Line 34:		Line 34:
	==See also==		==See also==
	{{Modules/MTA-MySQL/Result_functions}}		{{Modules/MTA-MySQL/Result_functions}}
	~~'''Bold text'''~~

Alberto Alonso at 18:02, 5 January 2011

2011-01-05T18:02:47Z

← Older revision		Revision as of 18:02, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}
Line 33:		Line 34:
	==See also==		==See also==
	{{Modules/MTA-MySQL/Result_functions}}		{{Modules/MTA-MySQL/Result_functions}}
			'''Bold text'''

Ryden at 18:03, 14 January 2008

2008-01-14T18:03:31Z

← Older revision		Revision as of 18:03, 14 January 2008
Line 1:		Line 1:
	__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.

Ryden: /* Example */

2008-01-14T17:00:16Z

Example

← Older revision		Revision as of 17:00, 14 January 2008
Line 27:		Line 27:
	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}}

Ryden: 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== iterator mysql_fields ( MySQLResult...

2008-01-14T16:54:39Z

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...

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 result )
</syntaxhighlight>
===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.
<syntaxhighlight lang="lua">
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
</syntaxhighlight>

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

Modules/MTA-MySQL/mysql fields - Revision history

Alberto Alonso: Oh god, not again.

Alberto Alonso at 18:02, 5 January 2011

Ryden at 18:03, 14 January 2008

Ryden: /* Example */

Ryden: 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== iterator mysql_fields ( MySQLResult...

Ryden: 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== iterator mysql_fields ( MySQLResult...