<!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>Fetch a result row as an associative array, a numeric array, or both</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-error.html">fbsql_error</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-assoc.html">fbsql_fetch_assoc</a></div>
<div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="function.fbsql-fetch-array" class="refentry">
<div class="refnamediv">
<h1 class="refname">fbsql_fetch_array</h1>
<p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_fetch_array</span> — <span class="dc-title">Fetch a result row as an associative array, a numeric array, or both</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.fbsql-fetch-array-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">array</span> <span class="methodname"><strong>fbsql_fetch_array</strong></span>
( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result</code></span>
[, <span class="methodparam"><span class="type">int</span> <code class="parameter">$result_type</code></span>
] )</div>
<p class="para rdfs-comment">
<span class="function"><strong>fbsql_fetch_array()</strong></span> is a combination of
<span class="function"><a href="function.fbsql-fetch-row.html" class="function">fbsql_fetch_row()</a></span> and
<span class="function"><a href="function.fbsql-fetch-assoc.html" class="function">fbsql_fetch_assoc()</a></span>.
</p>
<p class="para">
An important thing to note is that using
<span class="function"><strong>fbsql_fetch_array()</strong></span> is NOT significantly
slower than using <span class="function"><a href="function.fbsql-fetch-row.html" class="function">fbsql_fetch_row()</a></span>, while it
provides a significant added value.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.fbsql-fetch-array-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">A result identifier
returned by <span class="function"><a href="function.fbsql-query.html" class="function">fbsql_query()</a></span> or
<span class="function"><a href="function.fbsql-db-query.html" class="function">fbsql_db_query()</a></span>.</p></dd>
</dt>
<dt>
<span class="term"><em><code class="parameter">result_type</code></em></span>
<dd>
<p class="para">
A constant and can take the following values:
<strong><code>FBSQL_ASSOC</code></strong>, <strong><code>FBSQL_NUM</code></strong>, or
<strong><code>FBSQL_BOTH</code></strong>.
</p>
<p class="para">
When using <strong><code>FBSQL_BOTH</code></strong>, in addition to storing the
data in the numeric indices of the result array, it also stores the
data in associative indices, using the field names as keys.
</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.fbsql-fetch-array-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>
<p class="para">
If two or more columns of the result have the same field names,
the last column will take precedence. To access the other column(s)
of the same name, you must the numeric index of the column or
make an alias for the column.
<div class="informalexample">
<div class="example-contents">
<div class="sqlcode"><pre class="sqlcode">select t1.f1 as foo t2.f1 as bar from t1, t2</pre>
</div>
</div>
</div>
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.fbsql-fetch-array-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1123">
<p><strong>Example #1 <span class="function"><strong>fbsql_fetch_array()</strong></span> example</strong></p>
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br />fbsql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$host</span><span style="color: #007700">, </span><span style="color: #0000BB">$user</span><span style="color: #007700">, </span><span style="color: #0000BB">$password</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">fbsql_db_query</span><span style="color: #007700">(</span><span style="color: #DD0000">"database"</span><span style="color: #007700">, </span><span style="color: #DD0000">"select user_id, fullname from table"</span><span style="color: #007700">);<br />while (</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">fbsql_fetch_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">)) {<br /> echo </span><span style="color: #DD0000">"user_id: " </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">"user_id"</span><span style="color: #007700">] . </span><span style="color: #DD0000">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"user_id: " </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">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"fullname: " </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">"fullname"</span><span style="color: #007700">] . </span><span style="color: #DD0000">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"fullname: " </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">"<br />\n"</span><span style="color: #007700">;<br />}<br /></span><span style="color: #0000BB">fbsql_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 seealso" id="refsect1-function.fbsql-fetch-array-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.fbsql-fetch-row.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_row()</a> - Get a result row as an enumerated array</span></li>
<li class="member"> <span class="function"><a href="function.fbsql-fetch-assoc.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_assoc()</a> - Fetch a result row as an associative array</span></li>
<li class="member"> <span class="function"><a href="function.fbsql-fetch-object.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_object()</a> - Fetch a result row as an object</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.fbsql-error.html">fbsql_error</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-assoc.html">fbsql_fetch_assoc</a></div>
<div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
