<!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>Returns the error message from previous operation</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-errno.html">fbsql_errno</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-array.html">fbsql_fetch_array</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-error" class="refentry">
<div class="refnamediv">
<h1 class="refname">fbsql_error</h1>
<p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_error</span> — <span class="dc-title">Returns the error message from previous operation</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.fbsql-error-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">string</span> <span class="methodname"><strong>fbsql_error</strong></span>
([ <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code></span>
] )</div>
<p class="para rdfs-comment">
Returns the error message from previous FrontBase operation.
</p>
<p class="para">
Errors coming back from the fbsql database backend don't issue warnings.
Instead, use <span class="function"><strong>fbsql_error()</strong></span> to retrieve the error text.
Note that this function only returns the error code from the most recently
executed fbsql function (not including <span class="function"><strong>fbsql_error()</strong></span>
and <span class="function"><a href="function.fbsql-errno.html" class="function">fbsql_errno()</a></span>), so if you want to use it, make sure
you check the value before calling another fbsql function.
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.fbsql-error-parameters">
<h3 class="title">Parameters</h3>
<p class="para">
<dl>
<dt>
<span class="term"><em><code class="parameter">
link_identifier</code></em></span><dd>
<p class="para">A FrontBase link identifier
returned by <span class="function"><a href="function.fbsql-connect.html" class="function">fbsql_connect()</a></span> or
<span class="function"><a href="function.fbsql-pconnect.html" class="function">fbsql_pconnect()</a></span>.</p><p class="para">If optional and not specified,
the function will try to find an open link to the FrontBase server and if no
such link is found it will try to create one as if
<span class="function"><a href="function.fbsql-connect.html" class="function">fbsql_connect()</a></span> was called with no arguments.</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.fbsql-error-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns the error text from the last fbsql function, or
<em>''</em> (the empty string) if no error occurred.
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.fbsql-error-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1122">
<p><strong>Example #1 <span class="function"><strong>fbsql_error()</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: #DD0000">"marliesle"</span><span style="color: #007700">);<br />echo </span><span style="color: #0000BB">fbsql_errno</span><span style="color: #007700">() . </span><span style="color: #DD0000">": " </span><span style="color: #007700">. </span><span style="color: #0000BB">fbsql_error</span><span style="color: #007700">() . </span><span style="color: #DD0000">"<br />"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">fbsql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">"nonexistentdb"</span><span style="color: #007700">);<br />echo </span><span style="color: #0000BB">fbsql_errno</span><span style="color: #007700">() . </span><span style="color: #DD0000">": " </span><span style="color: #007700">. </span><span style="color: #0000BB">fbsql_error</span><span style="color: #007700">() . </span><span style="color: #DD0000">"<br />"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$conn </span><span style="color: #007700">= </span><span style="color: #0000BB">fbsql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT * FROM nonexistenttable;"</span><span style="color: #007700">);<br />echo </span><span style="color: #0000BB">fbsql_errno</span><span style="color: #007700">() . </span><span style="color: #DD0000">": " </span><span style="color: #007700">. </span><span style="color: #0000BB">fbsql_error</span><span style="color: #007700">() . </span><span style="color: #DD0000">"<br />"</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-error-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.fbsql-errno.html" class="function" rel="rdfs-seeAlso">fbsql_errno()</a> - Returns the error number from previous operation</span></li>
<li class="member"> <span class="function"><a href="function.fbsql-warnings.html" class="function" rel="rdfs-seeAlso">fbsql_warnings()</a> - Enable or disable FrontBase warnings</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-errno.html">fbsql_errno</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-array.html">fbsql_fetch_array</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>
