<!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 result data</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-read-clob.html">fbsql_read_clob</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-rollback.html">fbsql_rollback</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-result" class="refentry"> <div class="refnamediv"> <h1 class="refname">fbsql_result</h1> <p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_result</span> — <span class="dc-title">Get result data</span></p> </div> <div class="refsect1 description" id="refsect1-function.fbsql-result-description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <span class="methodname"><strong>fbsql_result</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">$row</code></span> [, <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <code class="parameter">$field</code></span> ]] )</div> <p class="para rdfs-comment"> Returns the contents of one cell from a FrontBase <em><code class="parameter">result</code></em> set. </p> <p class="para"> 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 <span class="function"><strong>fbsql_result()</strong></span>. </p> <p class="para"> Calls to <span class="function"><strong>fbsql_result()</strong></span> should not be mixed with calls to other functions that deal with the result set. </p> </div> <div class="refsect1 parameters" id="refsect1-function.fbsql-result-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">row</code></em></span> <dd> <p class="para"> </p> </dd> </dt> <dt> <span class="term"><em><code class="parameter">field</code></em></span> <dd> <p class="para"> Can be the field's offset, or the field's name, or the field's table dot field's name (tablename.fieldname). </p> <p class="para"> If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column name. </p> <blockquote class="note"><p><strong class="note">Note</strong>: <p class="para"> Specifying a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument. </p> </p></blockquote> </dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues" id="refsect1-function.fbsql-result-returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> </p> </div> <div class="refsect1 seealso" id="refsect1-function.fbsql-result-seealso"> <h3 class="title">See Also</h3> <p class="para"> Recommended high-performance alternatives: <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-array.html" class="function" rel="rdfs-seeAlso">fbsql_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.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-read-clob.html">fbsql_read_clob</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-rollback.html">fbsql_rollback</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>