Modules/MTA-MySQL/mysql field length
From Multi Theft Auto: Wiki
This function is provided by the external module MTA-MySQL. You must install this module to use this function. | |
Returns the length of a given field in the last retreived row. The offset of the field must be an integer between 1 and mysql_num_fields()
Syntax
int mysql_field_length ( MySQLResult result, int offset )
Required arguments
- result: A valid MySQL result
- offset: A valid offset
Returns
The given field data length.
Example
Example 1:
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) local length = mysql_field_length(result, 1) outputDebugString("The length of " .. row[1] .. " is " .. length) mysql_free_result(result) -- Free the result end