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

Alberto Alonso at 18:04, 5 January 2011

2011-01-05T18:04:18Z

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

Ryder! at 22:43, 24 March 2008

2008-03-24T22:43:57Z

← Older revision		Revision as of 22:43, 24 March 2008
Line 5:		Line 5:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	table ~~mysql_fetch_rows~~ ( MySQLResult result )		table mysql_fetch_row ( MySQLResult result )
	</syntaxhighlight>		</syntaxhighlight>
	===Required arguments===		===Required arguments===

Ryden at 18:03, 14 January 2008

2008-01-14T18:03:51Z

← Older revision		Revision as of 18:03, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Returns a 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()]]		Returns a 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()]]

Ryden: New page: NOTOC Returns a 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 r...

2008-01-14T17:18:08Z

New page: __NOTOC__ Returns a 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 r...

New page

__NOTOC__
Returns a 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_rows ( MySQLResult result )
</syntaxhighlight>
===Required arguments===
* '''result:''' A valid MySQL result

===Returns===
A 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 name FROM account") -- Execute the query
if (result) then
while true do
local row = mysql_fetch_row(result)
if (not row) then break end

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

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

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

Alberto Alonso at 18:04, 5 January 2011

Ryder! at 22:43, 24 March 2008

Ryden at 18:03, 14 January 2008

Ryden: New page: __NOTOC__ Returns a 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 r...

Ryden: New page: NOTOC Returns a 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 r...