Returns a mixed array with the query result entries, optionally limited to a maximum of
max_rows rows. Note that both row and column indexes are zero-based.
Table 1. Mixed result set returned by sesam_fetch_result()
| Array Element |
Contents |
| int $arr["count"] |
number of columns in result set (or zero if this was an
"immediate" query) |
| int $arr["rows"] |
number of rows in result set (between zero and
max_rows) |
| bool $arr["truncated"] |
TRUE if the number of rows was at least
max_rows, FALSE otherwise. Note that even when this is
TRUE, the next sesam_fetch_result() call may return zero rows because there are no
more result entries. |
| mixed $arr[col][row] |
result data for all the fields at row(row) and
column(col), (where the integer index row is between 0 and
$arr["rows"]-1, and col is between 0 and $arr["count"]-1). Fields may be
empty, so you must check for the existence of a field by using the php isset() function. The type of the returned fields depend on the
respective SQL type declared for its column (see SESAM overview for
the conversions applied). SESAM "multiple fields" are "inlined" and treated like a sequence of
columns. |
Note that the amount of memory used up by a large query may be gigantic. Use the
max_rows parameter to limit the maximum number of rows returned, unless you are absolutely
sure that your result will not use up all available memory.
See also: sesam_fetch_row(), and sesam_field_array() to check for "multiple
fields". See the description of the sesam_query()
function for a complete example using sesam_fetch_result().
