Modules/MTA-MySQL/mysql errno

From Multi Theft Auto: Wiki
Revision as of 14:48, 13 January 2008 by Ryden (talk | contribs) (New page: __NOTOC__ Returns the last error number of a MySQL connection. ==Syntax== <syntaxhighlight lang="lua"> mysql_errno ( MySQLConnection handler ) </syntaxhighlight> ===Required arguments=== * '''handler:''' A valid M...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Returns the last error number of a MySQL connection.

Syntax

mysql_errno ( MySQLConnection handler )

Required arguments

  • handler: A valid MySQL link

Returns

The last error number, zero if something failed. 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. 

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
end

See also

Retrieved from "https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL/mysql_errno?oldid=14862"