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

Alberto Alonso at 18:04, 5 January 2011

2011-01-05T18:04:05Z

← 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}}

Ryden at 18:03, 14 January 2008

2008-01-14T18:03:41Z

← Older revision		Revision as of 18:03, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil.		Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil.

Ryden: New page: NOTOC Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil. ==Syntax==...

2008-01-14T17:03:10Z

New page: __NOTOC__ Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil. ==Syntax==...

New page

__NOTOC__
Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil.

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

===Returns===
A table with the length of the values of the last retreived row.

===Example===
'''Example 1:''' This example shows the length of an account name
<syntaxhighlight lang="lua">
local result = mysql_query(handler, "SELECT name FROM account WHERE id='1' LIMIT 1") -- Execute the query
if (result) then
local row = mysql_fetch_row(result) -- Return the resulting row
local lengths = mysql_fetch_lengths(result) -- Retreive the lengths of the result fields
outputDebugString("The length of " .. row[1] .. " is " .. lengths[1])
mysql_free_result(result) -- Free the result
end
</syntaxhighlight>

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

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

Alberto Alonso at 18:04, 5 January 2011

Ryden at 18:03, 14 January 2008

Ryden: New page: __NOTOC__ Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil. ==Syntax==...

Ryden: New page: NOTOC Returns a table containing the length of the values of the last retreived row. If you didn't retreive any row or you are in the end of the result set, it returns nil. ==Syntax==...