Fetches a result, optionally limited to
A valid result id returned by sesam_query().
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
Returns a mixed array with the query result entries, optionally
limited to a maximum of
Note that both row and column indexes are zero-based.
Table 1. Mixed result set returned by sesam_fetch_result()
|int $arr["count"]||number of columns in result set (or zero if this was an "immediate" query)|
number of rows in result set (between zero and
TRUE if the number of rows was at least
|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.|