<!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>Get row as enumerated array</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.mssql-fetch-object.html">mssql_fetch_object</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.mssql-field-length.html">mssql_field_length</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-fetch-row" class="refentry">
<div class="refnamediv">
<h1 class="refname">mssql_fetch_row</h1>
<p class="verinfo">(PHP 4, PHP 5, PECL odbtp >= 1.1.1)</p><p class="refpurpose"><span class="refname">mssql_fetch_row</span> — <span class="dc-title">Get row as enumerated array</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.mssql-fetch-row-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">array</span> <span class="methodname"><strong>mssql_fetch_row</strong></span>
( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result</code></span>
)</div>
<p class="para rdfs-comment">
<span class="function"><strong>mssql_fetch_row()</strong></span> fetches one row of data from
the result associated with the specified result identifier. The
row is returned as an array. Each result column is stored in an
array offset, starting at offset 0.
</p>
<p class="para">
Subsequent call to <span class="function"><strong>mssql_fetch_row()</strong></span> would
return the next row in the result set, or <strong><code>FALSE</code></strong> if there are no
more rows.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.mssql-fetch-row-parameters">
<h3 class="title">Parameters</h3>
<p class="para">
<dl>
<dt>
<span class="term"><em><code class="parameter">result</code></em></span>
<dd>
<p class="para">
The result resource that is being evaluated. This result comes from a
call to <span class="function"><a href="function.mssql-query.html" class="function">mssql_query()</a></span>.
</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.mssql-fetch-row-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an array that corresponds to the fetched row, or <strong><code>FALSE</code></strong> if there
are no more rows.
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.mssql-fetch-row-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1532">
<p><strong>Example #1 <span class="function"><strong>mssql_fetch_row()</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">// Query to execute<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 [id], [quote] FROM [quotes] WHERE [id] = \'42\''</span><span style="color: #007700">, </span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Did the query fail?<br /></span><span style="color: #007700">if (!</span><span style="color: #0000BB">$query</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'MSSQL error: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">mssql_get_last_message</span><span style="color: #007700">());<br />}<br /><br /></span><span style="color: #FF8000">// Fetch the row<br /></span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_fetch_row</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Print the 'quote'<br /></span><span style="color: #007700">echo </span><span style="color: #DD0000">'Quote #' </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">] . </span><span style="color: #DD0000">': "' </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">] . </span><span style="color: #DD0000">'"'</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
<div class="example-contents"><p>The above example will output
something similar to:</p></div>
<div class="example-contents screen">
<div class="cdata"><pre>
Quote #42: "The answer to everything..."
</pre></div>
</div>
</div>
</p>
</div>
<div class="refsect1 notes" id="refsect1-function.mssql-fetch-row-notes">
<h3 class="title">Notes</h3>
<blockquote class="note"><p><strong class="note">Note</strong>: <span class="simpara">This function sets NULL fields to
the PHP <strong><code>NULL</code></strong> value.</span></p></blockquote>
</div>
<div class="refsect1 seealso" id="refsect1-function.mssql-fetch-row-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.mssql-fetch-array.html" class="function" rel="rdfs-seeAlso">mssql_fetch_array()</a> - Fetch a result row as an associative array, a numeric array, or both</span></li>
<li class="member"> <span class="function"><a href="function.mssql-fetch-object.html" class="function" rel="rdfs-seeAlso">mssql_fetch_object()</a> - Fetch row as object</span></li>
<li class="member"> <span class="function"><a href="function.mssql-data-seek.html" class="function" rel="rdfs-seeAlso">mssql_data_seek()</a> - Moves internal row pointer</span></li>
<li class="member"> <span class="function"><a href="function.mssql-result.html" class="function" rel="rdfs-seeAlso">mssql_result()</a> - Get result data</span></li>
</ul>
</p>
</div>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.mssql-fetch-object.html">mssql_fetch_object</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.mssql-field-length.html">mssql_field_length</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>
