<!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 from a query as an associative array</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.ibase-execute.html">ibase_execute</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ibase-fetch-object.html">ibase_fetch_object</a></div>
<div class="up"><a href="ref.ibase.html">Firebird/InterBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="function.ibase-fetch-assoc" class="refentry">
<div class="refnamediv">
<h1 class="refname">ibase_fetch_assoc</h1>
<p class="verinfo">(PHP 5)</p><p class="refpurpose"><span class="refname">ibase_fetch_assoc</span> — <span class="dc-title">Fetch a result row from a query as an associative array</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.ibase-fetch-assoc-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">array</span> <span class="methodname"><strong>ibase_fetch_assoc</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">$fetch_flag</code><span class="initializer"> = 0</span></span>
] )</div>
<p class="para rdfs-comment">
Fetch a result row from a query as an associative array.
</p>
<p class="para">
<span class="function"><strong>ibase_fetch_assoc()</strong></span> fetches one row of data from the
<em><code class="parameter">result</code></em>. 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 either need to access
the result with numeric indices by using
<span class="function"><a href="function.ibase-fetch-row.html" class="function">ibase_fetch_row()</a></span> or use alias names in your query.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.ibase-fetch-assoc-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 handle.
</p>
</dd>
</dt>
<dt>
<span class="term"><em><code class="parameter">fetch_flag</code></em></span>
<dd>
<p class="para">
<em><code class="parameter">fetch_flag</code></em> is a combination of the constants
<strong><code>IBASE_TEXT</code></strong> and <strong><code>IBASE_UNIXTIME</code></strong>
ORed together. Passing <strong><code>IBASE_TEXT</code></strong> will cause this
function to return BLOB contents instead of BLOB ids. Passing
<strong><code>IBASE_UNIXTIME</code></strong> will cause this function to return
date/time values as Unix timestamps instead of as formatted strings.
</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.ibase-fetch-assoc-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an associative array that corresponds to the fetched row.
Subsequent calls will 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 seealso" id="refsect1-function.ibase-fetch-assoc-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.ibase-fetch-row.html" class="function" rel="rdfs-seeAlso">ibase_fetch_row()</a> - Fetch a row from an InterBase database</span></li>
<li class="member"> <span class="function"><a href="function.ibase-fetch-object.html" class="function" rel="rdfs-seeAlso">ibase_fetch_object()</a> - Get an object from a InterBase database</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.ibase-execute.html">ibase_execute</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ibase-fetch-object.html">ibase_fetch_object</a></div>
<div class="up"><a href="ref.ibase.html">Firebird/InterBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
