sesam_fetch_result -- Return all or part of a query result
Syntax
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.
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.
sesam fetch result php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online
Php sesam fetch result syntax tutorial
php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.
