<!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.msql-regcase.html">msql_regcase</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.msql-select-db.html">msql_select_db</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-result" class="refentry">
<div class="refnamediv">
<h1 class="refname">msql_result</h1>
<p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">msql_result</span> — <span class="dc-title">Get result data</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.msql-result-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">string</span> <span class="methodname"><strong>msql_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">
<span class="function"><strong>msql_result()</strong></span> returns the contents of one cell from a
mSQL result 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 are often
much quicker than <span class="function"><strong>msql_result()</strong></span>.
</p>
<p class="para">
Recommended high-performance alternatives:
<span class="function"><a href="function.msql-fetch-row.html" class="function">msql_fetch_row()</a></span>,
<span class="function"><a href="function.msql-fetch-array.html" class="function">msql_fetch_array()</a></span>, and
<span class="function"><a href="function.msql-fetch-object.html" class="function">msql_fetch_object()</a></span>.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.msql-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">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>
<dt>
<span class="term"><em><code class="parameter">row</code></em></span>
<dd>
<p class="para">
The row offset.
</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.). 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 field offset is much quicker than specifying a
fieldname or tablename.fieldname.
</p>
</p></blockquote>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.msql-result-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns the contents of the cell at the row and offset in the
specified mSQL result set.
</p>
</div>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.msql-regcase.html">msql_regcase</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.msql-select-db.html">msql_select_db</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>
