update : 2015.11.03
php.shukuma.com

검색:
 
 
Set the row position before fetching data

ingres_result_seek

(PECL ingres >= 2.1.0)

ingres_result_seekSet 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");

/* goto row 3 */
if (!ingres_result_seek($result3))
{
    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);

?>

참고