Modules/MTA-MySQL/mysql field name: Difference between revisions
Jump to navigation
Jump to search
(New page: __NOTOC__ {{ModuleFunction|MTA-MySQL}} Returns the name of a given field in the last executed query. The offset of the field must be an integer between '''1''' and '''[[Modules/MTA-MySQL/m...) |
mNo edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass> | |||
__NOTOC__ | __NOTOC__ | ||
{{ModuleFunction|MTA-MySQL}} | {{ModuleFunction|MTA-MySQL}} | ||
Returns the name of a given field in the last executed query. The offset of the field must be an integer between '''1''' and '''[[Modules/MTA-MySQL/mysql_num_rows/mysql_num_fields()]]''' | Returns the name of a given field in the last executed query. The offset of the field must be an integer between '''1''' and '''[[Modules/MTA-MySQL/mysql_num_rows/mysql_num_fields|mysql_num_fields()]]''' | ||
==Syntax== | ==Syntax== | ||
Latest revision as of 18:06, 5 January 2011
|
This function is provided by the external module MTA-MySQL. You must install this module to use this function. |
Returns the name of a given field in the last executed query. The offset of the field must be an integer between 1 and mysql_num_fields()
Syntax
int mysql_field_name ( MySQLResult result, int offset )
Required arguments
- result: A valid MySQL result
- offset: A valid offset
Returns
The given field name.
Example
Example 1:
local result = mysql_query(handler, "SELECT name FROM account WHERE id='1' LIMIT 1") -- Execute the query if (result) then local str = mysql_field_name(result, 1) outputDebugString(str) -- Will print 'name' mysql_free_result(result) -- Free the result end