ingres_queryingres_result_seek
(PECL ingres >= 2.1.0)
ingres_result_seek — Set the row position before fetching data
설명
This function is used to position the cursor associated with the result resource before issuing a fetch. If ingres.array_index_start is set to 0 then the first row is 0 else it is 1. ingres_result_seek() can be used only with queries that make use of scrollable cursors. It cannot be used with ingres_unbuffered_query().
Note: Related Configurations
See also the ingres.scrollable and ingres.array_index_start directives in Runtime Configuration.
인수
- result
-
The result identifier for a query
- position
-
The row to position the cursor on. If ingres.array_index_start is set to 0, then the first row is 0, else it is 1
반환값
성공할 경우 TRUE를, 실패할 경우 FALSE를 반환합니다.
예제
Example #1 Position the cursor on the 3rd row
<?php
$result=ingres_query($link, "select * from airport where ap_ccode = 'ES' order by ap_place asc");
/* goto row 3 */
if (!ingres_result_seek($result, 3))
{
echo ingres_errno() . " - " . ingres_error . "\n";
die("i died");
}
else
{
$airport = ingres_fetch_object ($result);
{
echo $airport->ap_iatacode . " - " . $airport->ap_name . "\n";
}
}
ingres_commit($link);
?>
참고
- ingres_query() - Send an SQL query to Ingres
- ingres_fetch_array() - Fetch a row of result into an array
- ingres_fetch_assoc() - Fetch a row of result into an associative array
- ingres_fetch_object() - Fetch a row of result into an object
- ingres_fetch_row() - Fetch a row of result into an enumerated array
add a note
User Contributed Notes
ingres_result_seek