Modules/MTA-MySQL/mysql rows: Difference between revisions
Jump to navigation
Jump to search
(New page: __NOTOC__ Creates an iterator for the result rows. When this function is called, the row cursor is set to the first result row. ==Syntax== <syntaxhighlight lang="lua"> iterator mysql_rows ( MySQLResult ...) |
(No difference)
|
Revision as of 17:21, 14 January 2008
Creates an iterator for the result rows. When this function is called, the row cursor is set to the first result row.
Syntax
iterator mysql_rows ( MySQLResult result )
Required arguments
- result: A valid MySQL result
Returns
An iterator function to iterate all the result rows.
Example
Example 1: This example prints all the accounts names
local result = mysql_query(handler, "SELECT name FROM account") -- Execute the query
if (result) then
for result,row in mysql_rows(result) do
outputDebugString(row[1])
end
mysql_free_result(result) -- Free the result
end