row([$n = 0[, $type = 'object']]) Parameters: $n (int) – Index of the query results row to be returned $type (string) – Type of the requested result - array, object, or class name Returns: The requested row or NULL if it doesn’t exist Return type: mixed A wrapper for the row_array(), row_object() and ``custom_row_object() methods. Usage: see Result Rows.

result_object() Returns: Array containing the fetched rows Return type: array Returns the query results as an array of rows, where each row is an object of type stdClass. Usage: see Result Arrays.

result_array() Returns: Array containing the fetched rows Return type: array Returns the query results as an array of rows, where each row is itself an associative array. Usage: see Result Arrays.

result([$type = 'object']) Parameters: $type (string) – Type of requested results - array, object, or class name Returns: Array containing the fetched rows Return type: array A wrapper for the result_array(), result_object() and custom_result_object() methods. Usage: see Result Arrays.

previous_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Previous row of result set, or NULL if it doesn’t exist Return type: mixed Returns the previous row from the result set.

num_rows() Returns: Number of rows in the result set Return type: int Returns the number of rows in the result set. Usage: see Result Helper Methods.

num_fields() Returns: Number of fields in the result set Return type: int Returns the number of fields in the result set. Usage: see Result Helper Methods.

next_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Next row of result set, or NULL if it doesn’t exist Return type: mixed Returns the next row from the result set.

list_fields() Returns: Array of column names Return type: array Returns an array containing the field names in the result set.

last_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Last row of result set, or NULL if it doesn’t exist Return type: mixed Returns the last row from the result set.