JavaScript Editor Javascript debugger     Website design 


Set internal row offset in result resource (PHP 4 >= 4.3.0, PHP 5)
bool pg_result_seek ( resource result, int offset )

pg_result_seek() sets the internal row offset in a result resource.



PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).


Row to move the internal offset to in the result resource. Rows are numbered starting from zero.

Return Values

Returns TRUE on success or FALSE on failure.


Example 1969. pg_result_seek() example


// Connect to the database
$conn = pg_pconnect("dbname=publisher");

// Execute a query
$result = pg_query($conn, "SELECT author, email FROM authors");

// Seek to the 3rd row (assuming there are 3 rows)
pg_result_seek($result, 2);

// Fetch the 3rd row
$row = pg_fetch_row($result);