ingres_result_seek

(PECL ingres >= 2.1.0)

ingres_result_seek — Set the row position before fetching data

说明

bool ingres_result_seek ( resource $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 );

 ?>

参见

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