Modules/MTA-MySQL/mysql error - Revision history

Reitside at 16:03, 2 December 2017

2017-12-02T16:03:58Z

← Older revision		Revision as of 16:03, 2 December 2017
Line 28:		Line 28:
	{{Modules/MTA-MySQL/Handler_functions}}		{{Modules/MTA-MySQL/Handler_functions}}

	[[RU:Modules/MTA-MySQL/~~mysql_errno~~]]		[[RU:Modules/MTA-MySQL/mysql_error]]

Reitside at 15:45, 2 December 2017

2017-12-02T15:45:58Z

← Older revision		Revision as of 15:45, 2 December 2017
Line 27:		Line 27:
	==See also==		==See also==
	{{Modules/MTA-MySQL/Handler_functions}}		{{Modules/MTA-MySQL/Handler_functions}}

			[[RU:Modules/MTA-MySQL/mysql_errno]]

Alberto Alonso at 17:39, 5 January 2011

2011-01-05T17:39:51Z

← Older revision		Revision as of 17:39, 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 17:58, 14 January 2008

2008-01-14T17:58:33Z

← Older revision		Revision as of 17:58, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Returns the last error string of a MySQL connection.		Returns the last error string of a MySQL connection.

Ryden: /* Example */

2008-01-13T14:53:13Z

Example

← Older revision		Revision as of 14:53, 13 January 2008
Line 19:		Line 19:
	outputDebugString("mysql_query failed: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) -- Show the reason		outputDebugString("mysql_query failed: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) -- Show the reason
	else		else
	mysql_free_result(result)		mysql_free_result(result) -- Free the last query result data
	end		end
	</syntaxhighlight>		</syntaxhighlight>

Ryden: New page: NOTOC Returns the last error string of a MySQL connection. ==Syntax== string mysql_error ( MySQLConnection handler ) ===Required arguments=== * '''handler:''' A ...

2008-01-13T14:52:51Z

New page: __NOTOC__ Returns the last error string of a MySQL connection. ==Syntax== <syntaxhighlight lang="lua"> string mysql_error ( MySQLConnection handler ) </syntaxhighlight> ===Required arguments=== * '''handler:''' A ...

New page

__NOTOC__
Returns the last error string of a MySQL connection.

==Syntax==
<syntaxhighlight lang="lua">
string mysql_error ( MySQLConnection handler )
</syntaxhighlight>
===Required arguments===
* '''handler:''' A valid MySQL link

===Returns===
The last error string. Visit http://dev.mysql.com/doc/refman/5.0/en/error-handling.html for a list of error codes.

==Example==
'''Example 1:''' This example sends a query to the server and if it fails, shows the reason.
<syntaxhighlight lang="lua">
result = mysql_query(handler, "SELECT FROM table") -- We have a syntax error in the query
if (not result) then -- The query failed
outputDebugString("mysql_query failed: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler)) -- Show the reason
else
mysql_free_result(result)
end
</syntaxhighlight>

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