Source of: /manual/en/function.mssql-result.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-result.php',
1 => 'mssql_result',
),
'up' =>
array (
0 => 'ref.mssql.php',
1 => 'Mssql Functions',
),
'prev' =>
array (
0 => 'function.mssql-query.php',
1 => 'mssql_query',
),
'next' =>
array (
0 => 'function.mssql-rows-affected.php',
1 => 'mssql_rows_affected',
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div id="function.mssql-result" class="refentry">
<div class="refnamediv">
<h1 class="refname">mssql_result</h1>
<p class="verinfo">(PHP 4, PHP 5, PECL odbtp >= 1.1.1)</p><p class="refpurpose"><span class="refname">mssql_result</span> — <span class="dc-title">Get result data</span></p>
</div>
<a name="function.mssql-result.description"></a><div class="refsect1 description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">string</span> <span class="methodname"><b>mssql_result</b></span>
( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span>
, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$row</tt></span>
, <span class="methodparam"><span class="type"><a href="language.pseudo-types.php#language.types.mixed" class="type mixed">mixed</a></span> <tt class="parameter">$field</tt></span>
)</div>
<p class="para rdfs-comment">
<b>mssql_result()</b> returns the contents of one cell from a
MS SQL result set.
</p>
</div>
<a name="function.mssql-result.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</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
The result resource that is being evaluated. This result comes from a
call to <a href="function.mssql-query.php" class="function">mssql_query()</a>.
</p>
</dd>
<dt class="varlistentry">
<span class="term"><i><tt class="parameter">row</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
The row number.
</p>
</dd>
<dt class="varlistentry">
<span class="term"><i><tt class="parameter">field</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
Can be the field's offset, the field's name or the field's table dot
field's name (tablename.fieldname). If the column name has been
aliased ('select foo as bar from...'), it uses the alias instead of
the column name.
</p>
<blockquote><p><b class="note">Note</b>:
Specifying a numeric offset for the <i><tt class="parameter">field</tt></i>
argument is much quicker than specifying a
<i>fieldname</i> or
<i>tablename.fieldname</i> argument.
<br />
</p></blockquote>
</dd>
</dl>
<p>
</p>
</div>
<a name="function.mssql-result.returnvalues"></a><div class="refsect1 returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns the contents of the specified cell.
</p>
</div>
<a name="function.mssql-result.examples"></a><div class="refsect1 examples">
<h3 class="title">Examples</h3>
<p class="para">
</p><div class="example">
<p><b>Example #1 <b>mssql_result()</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">// Send a select query to MSSQL<br /></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT [username] FROM [php].[dbo].[userlist]'</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Check if there were any records<br /></span><span style="color: #007700">if(!</span><span style="color: #0000BB">mssql_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">))<br />{<br /> echo </span><span style="color: #DD0000">'No records found'</span><span style="color: #007700">;<br />}<br />else<br />{<br /> for(</span><span style="color: #0000BB">$i </span><span style="color: #007700">= </span><span style="color: #0000BB">0</span><span style="color: #007700">; </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">$query</span><span style="color: #007700">); ++</span><span style="color: #0000BB">$i</span><span style="color: #007700">)<br /> {<br /> echo </span><span style="color: #0000BB">mssql_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">, </span><span style="color: #0000BB">$i</span><span style="color: #007700">, </span><span style="color: #DD0000">'username'</span><span style="color: #007700">), </span><span style="color: #0000BB">PHP_EOL</span><span style="color: #007700">;<br /> }<br />}<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">$query</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
<div class="example-contents para"><p>The above example will output
something similar to:</p></div>
<div class="example-contents screen">
<div class="cdata"><pre>
Kalle
Felipe
Emil
Ross
</pre></div>
</div>
</div><p>
</p>
<p class="para">
</p><div class="example">
<p><b>Example #2 Faster alternative to above 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">// Send a select query to MSSQL<br /></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT [username] FROM [php].[dbo].[userlist]'</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Check if there were any records<br /></span><span style="color: #007700">if(!</span><span style="color: #0000BB">mssql_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">))<br />{<br /> echo </span><span style="color: #DD0000">'No records found'</span><span style="color: #007700">;<br />}<br />else<br />{<br /> while(</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_fetch_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">))<br /> {<br /> echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">'username'</span><span style="color: #007700">], </span><span style="color: #0000BB">PHP_EOL</span><span style="color: #007700">;<br /> }<br />}<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">$query</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div><p>
</p>
</div>
<a name="function.mssql-result.notes"></a><div class="refsect1 notes">
<h3 class="title">Notes</h3>
<blockquote><p><b class="note">Note</b>:
When working on large result sets, you should consider using one of the
functions that fetch an entire row (specified below). As these functions
return the contents of multiple cells in one function call, they're MUCH
quicker than <b>mssql_result()</b>.
<br />
</p></blockquote>
</div>
<a name="function.mssql-result.seealso"></a><div class="refsect1 seealso">
<h3 class="title">See Also</h3>
<p class="para">
Recommended high-performance alternatives:
</p><ul class="simplelist">
<li class="member"><a href="function.mssql-fetch-row.php" class="function" rel="rdfs-seeAlso">mssql_fetch_row()</a> - Get row as enumerated array</li>
<li class="member"><a href="function.mssql-fetch-array.php" class="function" rel="rdfs-seeAlso">mssql_fetch_array()</a> - Fetch a result row as an associative array, a numeric array, or both</li>
<li class="member"><a href="function.mssql-fetch-assoc.php" class="function" rel="rdfs-seeAlso">mssql_fetch_assoc()</a> - Returns an associative array of the current row in the result</li>
<li class="member"><a href="function.mssql-fetch-object.php" class="function" rel="rdfs-seeAlso">mssql_fetch_object()</a> - Fetch row as object</li>
</ul><p>
</p>
</div>
</div><?php manual_footer(); ?>
