<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Moves internal row pointer</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.mssql-connect.html">mssql_connect</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.mssql-execute.html">mssql_execute</a></div>
<div class="up"><a href="ref.mssql.html">Mssql Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="function.mssql-data-seek" class="refentry">
<div class="refnamediv">
<h1 class="refname">mssql_data_seek</h1>
<p class="verinfo">(PHP 4, PHP 5, PECL odbtp >= 1.1.1)</p><p class="refpurpose"><span class="refname">mssql_data_seek</span> — <span class="dc-title">Moves internal row pointer</span></p>
</div>
<div id="function.mssql-data-seek-refsynopsisdiv">
<div class="warning"><strong class="warning">Warning</strong>
<p class="para">
This function was <em class="emphasis">REMOVED</em> in PHP 7.0.0.
</p>
<p class="para">
Alternatives to this function include:
</p>
<ul class="simplelist">
<li class="member">
Using an <em>OFFSET</em> clause with a query issued through
<a href="ref.pdo-sqlsrv.html" class="link">PDO_SQLSRV</a>,
<a href="ref.pdo-odbc.html" class="link">PDO_ODBC</a>,
<a href="book.sqlsrv.html" class="link">SQLSRV</a>, or the
<a href="book.uodbc.html" class="link">unified ODBC driver</a>.
</li>
</ul>
</div>
</div>
<div class="refsect1 description" id="refsect1-function.mssql-data-seek-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">bool</span> <span class="methodname"><strong>mssql_data_seek</strong></span>
( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result_identifier</code></span>
, <span class="methodparam"><span class="type">int</span> <code class="parameter">$row_number</code></span>
)</div>
<p class="para rdfs-comment">
<span class="function"><strong>mssql_data_seek()</strong></span> moves the internal row
pointer of the MS SQL result associated with the specified result
identifier to point to the specified row number, first row being
number 0. The next call to <span class="function"><a href="function.mssql-fetch-row.html" class="function">mssql_fetch_row()</a></span>
would return that row.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.mssql-data-seek-parameters">
<h3 class="title">Parameters</h3>
<p class="para">
<dl>
<dt>
<code class="parameter">result_identifier</code></dt>
<dd>
<p class="para">
The result resource that is being evaluated.
</p>
</dd>
<dt>
<code class="parameter">row_number</code></dt>
<dd>
<p class="para">
The desired row number of the new result pointer.
</p>
</dd>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.mssql-data-seek-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns <strong><code>TRUE</code></strong> on success or <strong><code>FALSE</code></strong> on failure.
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.mssql-data-seek-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1797">
<p><strong>Example #1 <span class="function"><strong>mssql_data_seek()</strong></span> example</strong></p>
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br /></span><span style="color: #FF8000">// Connect to MSSQL and select the database<br /></span><span style="color: #0000BB">$link </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'MANGO\SQLEXPRESS'</span><span style="color: #007700">, </span><span style="color: #DD0000">'sa'</span><span style="color: #007700">, </span><span style="color: #DD0000">'phpfi'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">mssql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">'php'</span><span style="color: #007700">, </span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Select all people<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT [name], [age] FROM [persons] WHERE [age] >= 13'</span><span style="color: #007700">);<br /><br />if (!</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Query failed.'</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #FF8000">// Select every 4th student in the results<br /></span><span style="color: #007700">for (</span><span style="color: #0000BB">$i </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">) - </span><span style="color: #0000BB">1</span><span style="color: #007700">; </span><span style="color: #0000BB">$i </span><span style="color: #007700">% </span><span style="color: #0000BB">4</span><span style="color: #007700">; </span><span style="color: #0000BB">$i</span><span style="color: #007700">++) {<br /> if (!</span><span style="color: #0000BB">mssql_data_seek</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">, </span><span style="color: #0000BB">$i</span><span style="color: #007700">)) {<br /> continue;<br /> }<br /><br /> </span><span style="color: #FF8000">// Fetch the row ...<br /></span><span style="color: #007700">}<br /><br /></span><span style="color: #FF8000">// Free the query result<br /></span><span style="color: #0000BB">mssql_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div>
</p>
</div>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.mssql-connect.html">mssql_connect</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.mssql-execute.html">mssql_execute</a></div>
<div class="up"><a href="ref.mssql.html">Mssql Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
