©
本文档使用 PHP中文网手册 发布
(PECL ingres >= 2.1.0)
ingres_result_seek — Set the row position before fetching data
$result
, int $position
)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" );
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 );
?>