SQLite

Functions that return an array of results can take an optional result_type argument to determine what type of array is created. These are the valid constants:

• SQLITE_ASSOC causes the array to use the string type column name as the array index.

• SQLITE_NUM causes the array to use a numerical index starting from zero for each column in the result.

• SQLITE_BOTH causes the array to use both string and numerical keys.

If no constant is specified, SQLITE_BOTH is assumed.