<HTML ><HEAD ><TITLE >sesam_seek_row</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="SESAM database functions" HREF="ref.sesam.html"><LINK REL="PREVIOUS" TITLE="sesam_rollback" HREF="function.sesam-rollback.html"><LINK REL="NEXT" TITLE="sesam_settransaction" HREF="function.sesam-settransaction.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.sesam-rollback.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.sesam-settransaction.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.sesam-seek-row" ></A >sesam_seek_row</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN83713" ></A ><P > (PHP 3 CVS only)</P >sesam_seek_row -- Set scrollable cursor mode for subsequent fetches </DIV ><DIV CLASS="refsect1" ><A NAME="AEN83716" ></A ><H2 >Description</H2 >bool <B CLASS="methodname" >sesam_seek_row</B > ( string result_id, int whence [, int offset])<BR ></BR ><P > <TT CLASS="parameter" ><I >result_id</I ></TT > is a valid result id (select type queries only, and only if a "scrollable" cursor was requested when calling <A HREF="function.sesam-query.html" ><B CLASS="function" >sesam_query()</B ></A >). </P ><P > <TT CLASS="parameter" ><I >whence</I ></TT > sets the global default value for the scrolling type, it specifies the scroll type to use in subsequent fetch operations on "scrollable" cursors, which can be set to the following predefined constants: <DIV CLASS="table" ><A NAME="AEN83735" ></A ><P ><B >Table 1. Valid values for <TT CLASS="parameter" ><I >"whence"</I ></TT > parameter</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><THEAD ><TR ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Value</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Constant</TH ><TH ALIGN="LEFT" VALIGN="MIDDLE" >Meaning</TH ></TR ></THEAD ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >0</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_NEXT</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >read sequentially </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >1</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_PRIOR</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >read sequentially backwards </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >2</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_FIRST</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > fetch first row (after fetch, the default is set to <TT CLASS="literal" >SESAM_SEEK_NEXT</TT >) </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >3</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_LAST</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > fetch last row (after fetch, the default is set to <TT CLASS="literal" >SESAM_SEEK_PRIOR</TT >) </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >4</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_ABSOLUTE</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > fetch absolute row number given as <TT CLASS="parameter" ><I >offset</I ></TT > (Zero-based. After fetch, the default is set to <TT CLASS="literal" >SESAM_SEEK_ABSOLUTE</TT >, and the offset value is auto-incremented) </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" >5</TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="literal" >SESAM_SEEK_RELATIVE</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > fetch relative to current scroll position, where <TT CLASS="parameter" ><I >offset</I ></TT > can be a positive or negative offset value (this also sets the default "offset" value for subsequent fetches). </TD ></TR ></TBODY ></TABLE ></DIV > </P ><P > <TT CLASS="parameter" ><I >offset</I ></TT > is an optional parameter which is only evaluated (and required) if <TT CLASS="parameter" ><I >whence</I ></TT > is either <TT CLASS="literal" >SESAM_SEEK_RELATIVE</TT > or <TT CLASS="literal" >SESAM_SEEK_ABSOLUTE</TT >. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.sesam-rollback.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.sesam-settransaction.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >sesam_rollback</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.sesam.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >sesam_settransaction</TD ></TR ></TABLE ></DIV ></BODY ></HTML >