Alberto Alonso at 18:05, 5 January 2011

2011-01-05T18:05:05Z

← Older revision		Revision as of 18:05, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}

Ryden: New page: NOTOC {{ModuleFunction|MTA-MySQL}} Returns an associative table containing the current row of the last executed query. You can call this function repeatedly to retreive all the result ...

2008-01-14T18:34:02Z

New page: __NOTOC__ {{ModuleFunction|MTA-MySQL}} Returns an associative table containing the current row of the last executed query. You can call this function repeatedly to retreive all the result ...

New page

__NOTOC__
{{ModuleFunction|MTA-MySQL}}
Returns an associative table containing the current row of the last executed query. You can call this function repeatedly to retreive all the result rows. When there aren't more rows in the result it returns nil. You can go to a specific row calling [[Modules/MTA-MySQL/mysql_data_seek|mysql_data_seek()]]

==Syntax==
<syntaxhighlight lang="lua">
table mysql_fetch_assoc ( MySQLResult result )
</syntaxhighlight>
===Required arguments===
* '''result:''' A valid MySQL result

===Returns===
An associative table with the current row

===Example===
'''Example 1:''' This example shows the name of all the registered accounts
<syntaxhighlight lang="lua">
local result = mysql_query(handler, "SELECT * FROM account") -- Execute the query
if (result) then
while true do
local row = mysql_fetch_assoc(result)
if (not row) then break end

outputDebugString(row["name"])
end
mysql_free_result(result) -- Free the result
end
</syntaxhighlight>

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

Modules/MTA-MySQL/mysql fetch assoc - Revision history

Alberto Alonso at 18:05, 5 January 2011

Ryden: New page: __NOTOC__ {{ModuleFunction|MTA-MySQL}} Returns an associative table containing the current row of the last executed query. You can call this function repeatedly to retreive all the result ...

Ryden: New page: NOTOC {{ModuleFunction|MTA-MySQL}} Returns an associative table containing the current row of the last executed query. You can call this function repeatedly to retreive all the result ...