IT. Expert System.

PHP

Set the row position before fetching data


ingres_result_seek

(PECL ingres >= 2.1.0)

ingres_result_seekSet the row position before fetching data

Description

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.

Parameters

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

Return Values

Returns TRUE on success or FALSE on failure.

Examples

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

?>

See Also



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 632 / 158670860. Delta: 0.03313 с