<!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 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> <span class="term"><em><code class="parameter">result_identifier</code></em></span> <dd> <p class="para"> The result resource that is being evaluated. </p> </dd> </dt> <dt> <span class="term"><em><code class="parameter">row_number</code></em></span> <dd> <p class="para"> The desired row number of the new result pointer. </p> </dd> </dt> </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-1525"> <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>