PHP: sesam_fetch_result - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

sesam_fetch_row sesam_fetch_array

Last updated: Fri, 26 Jan 2007

view this page in

# sesam_fetch_result

(PHP 3 CVS only)

sesam_fetch_result -- Return all or part of a query result

## Description

mixed sesam_fetch_result ( string result_id [, int max_rows] )

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.

Таблица 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().

add a note User Contributed Notes
sesam_fetch_result
There are no user contributed notes for this page.
sesam_fetch_row sesam_fetch_array

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST