<!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.msql-fetch-object.html">msql_fetch_object</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.msql-field-flags.html">msql_field_flags</a></div> <div class="up"><a href="ref.msql.html">mSQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="function.msql-fetch-row" class="refentry"> <div class="refnamediv"> <h1 class="refname">msql_fetch_row</h1> <p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">msql_fetch_row</span> — <span class="dc-title">Get row as enumerated array</span></p> </div> <div class="refsect1 description" id="refsect1-function.msql-fetch-row-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">array</span> <span class="methodname"><strong>msql_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>msql_fetch_row()</strong></span> fetches one row of data from the result associated with the specified query 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>msql_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.msql-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 <span class="type"><a href="language.types.resource.html" class="type resource">resource</a></span> that is being evaluated. This result comes from a call to <span class="function"><a href="function.msql-query.html" class="function">msql_query()</a></span>.</p></dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues" id="refsect1-function.msql-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.msql-fetch-row-examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example" id="example-1520"> <p><strong>Example #1 <span class="function"><strong>msql_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 />$con </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_connect</span><span style="color: #007700">();<br />if (!</span><span style="color: #0000BB">$con</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Server connection problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br />if (!</span><span style="color: #0000BB">msql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">'test'</span><span style="color: #007700">, </span><span style="color: #0000BB">$con</span><span style="color: #007700">)) {<br /> die(</span><span style="color: #DD0000">'Database connection problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT id, name FROM people'</span><span style="color: #007700">, </span><span style="color: #0000BB">$con</span><span style="color: #007700">);<br />if (!</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Query execution problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br />while (</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_fetch_row</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">)) {<br /> echo </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">"\n"</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #0000BB">msql_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 class="refsect1 changelog" id="refsect1-function.msql-fetch-row-changelog"> <h3 class="title">Changelog</h3> <p class="para"> <table class="doctable informaltable"> <thead> <tr> <th>Version</th> <th>Description</th> </tr> </thead> <tbody class="tbody"> <tr> <td>4.3.11 and 5.0.4 </td> <td> A bug was fixed when retrieving data from columns containing <strong><code>NULL</code></strong> values. Such columns were not placed into the resulting array. </td> </tr> </tbody> </table> </p> </div> <div class="refsect1 seealso" id="refsect1-function.msql-fetch-row-seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"> <span class="function"><a href="function.msql-fetch-array.html" class="function" rel="rdfs-seeAlso">msql_fetch_array()</a> - Fetch row as array</span></li> <li class="member"> <span class="function"><a href="function.msql-fetch-object.html" class="function" rel="rdfs-seeAlso">msql_fetch_object()</a> - Fetch row as object</span></li> <li class="member"> <span class="function"><a href="function.msql-data-seek.html" class="function" rel="rdfs-seeAlso">msql_data_seek()</a> - Move internal row pointer</span></li> <li class="member"> <span class="function"><a href="function.msql-result.html" class="function" rel="rdfs-seeAlso">msql_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.msql-fetch-object.html">msql_fetch_object</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.msql-field-flags.html">msql_field_flags</a></div> <div class="up"><a href="ref.msql.html">mSQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>