Modules/MTA-MySQL/mysql field length

	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 Modules/MTA-MySQL/mysql_num_rows/mysql_num_rows()

Syntax

int mysql_field_length ( MySQLResult result, int offset )

Required arguments

• result: A valid MySQL result
• offset: A valid offset

Returns

The given row 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

See also

• mysql_data_seek
• mysql_fetch_field
• mysql_fields
• mysql_fetch_lengths
• mysql_fetch_row
• mysql_rows
• mysql_fetch_assoc
• mysql_rows_assoc
• mysql_field_length
• mysql_field_name
• mysql_field_seek
• mysql_field_tell
• mysql_num_fields
• mysql_num_rows
• mysql_result
• mysql_free_result
• mysql_null