Source of: /manual/en/function.mssql-data-seek.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.mssql.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'en',
),
'this' =>
array (
0 => 'function.mssql-data-seek.php',
1 => 'mssql_data_seek',
),
'up' =>
array (
0 => 'ref.mssql.php',
1 => 'Mssql Functions',
),
'prev' =>
array (
0 => 'function.mssql-connect.php',
1 => 'mssql_connect',
),
'next' =>
array (
0 => 'function.mssql-execute.php',
1 => 'mssql_execute',
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<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>
<a name="function.mssql-data-seek.description"></a><div class="refsect1 description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">bool</span> <span class="methodname"><b>mssql_data_seek</b></span>
( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result_identifier</tt></span>
, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$row_number</tt></span>
)</div>
<p class="para rdfs-comment">
<b>mssql_data_seek()</b> 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 <a href="function.mssql-fetch-row.php" class="function">mssql_fetch_row()</a>
would return that row.
</p>
</div>
<a name="function.mssql-data-seek.parameters"></a><div class="refsect1 parameters">
<h3 class="title">Parameters</h3>
<p class="para">
</p><dl>
<dt class="varlistentry">
<span class="term"><i><tt class="parameter">result_identifier</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
The result resource that is being evaluated.
</p>
</dd>
<dt class="varlistentry">
<span class="term"><i><tt class="parameter">row_number</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
The desired row number of the new result pointer.
</p>
</dd>
</dl>
<p>
</p>
</div>
<a name="function.mssql-data-seek.returnvalues"></a><div class="refsect1 returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns <b><tt class="constant">TRUE</tt></b> on success or <b><tt class="constant">FALSE</tt></b> on failure.
</p>
</div>
<a name="function.mssql-data-seek.examples"></a><div class="refsect1 examples">
<h3 class="title">Examples</h3>
<p class="para">
</p><div class="example">
<p><b>Example #1 <b>mssql_data_seek()</b> example</b></p>
<div class="example-contents programlisting">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br /></span><span style="color: #FF8000">// Connect to MSSQL<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 />{<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 />{<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 /> {<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>
</p>
</div>
</div><?php manual_footer(); ?>
