<!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 number of affected rows in previous FrontBase operation</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="ref.fbsql.html">FrontBase Functions</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-autocommit.html">fbsql_autocommit</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-affected-rows" class="refentry">
<div class="refnamediv">
<h1 class="refname">fbsql_affected_rows</h1>
<p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_affected_rows</span> — <span class="dc-title">Get number of affected rows in previous FrontBase operation</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.fbsql-affected-rows-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">int</span> <span class="methodname"><strong>fbsql_affected_rows</strong></span>
([ <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code></span>
] )</div>
<p class="para rdfs-comment">
<span class="function"><strong>fbsql_affected_rows()</strong></span> returns the number
of rows affected by the last INSERT, UPDATE or DELETE query
associated with <em><code class="parameter">link_identifier</code></em>.
</p>
<blockquote class="note"><p><strong class="note">Note</strong>:
<p class="para">
If you are using transactions, you need to call
<span class="function"><strong>fbsql_affected_rows()</strong></span> after your INSERT,
UPDATE, or DELETE query, not after the commit.
</p>
</p></blockquote>
<p class="para">
If the last query was a DELETE query with no WHERE clause, all of
the records will have been deleted from the table but this
function will return zero.
</p>
<blockquote class="note"><p><strong class="note">Note</strong>:
<p class="para">
When using UPDATE, FrontBase will not update columns where the
new value is the same as the old value. This creates the
possibility that <span class="function"><strong>fbsql_affected_rows()</strong></span> may not
actually equal the number of rows matched, only the number of
rows that were literally affected by the query.
</p>
</p></blockquote>
</div>
<div class="refsect1 parameters" id="refsect1-function.fbsql-affected-rows-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-affected-rows-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
If the last query failed, this function will return -1.
</p>
</div>
<div class="refsect1 seealso" id="refsect1-function.fbsql-affected-rows-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.fbsql-num-rows.html" class="function" rel="rdfs-seeAlso">fbsql_num_rows()</a> - Get number of rows in result</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="ref.fbsql.html">FrontBase Functions</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-autocommit.html">fbsql_autocommit</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>
