Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:affected_rows [2016/01/16 22:36] – ↷ Page moved from v5:reference:affected_rows to v5:reference:connection:affected_rows mnewnham
+++ v5:reference:connection:affected_rows [2022/11/06 23:20] (current) – mnewnham
@@ Line 6: / Line 6: @@
 </WRAP>
 ===== Description =====
-The function ''affected_rows()'' returns the number of rows affected (add/change/delete) by the last SQL statement executed, or false if the database does not support the function or the statement is not an update. See the driver documentation for support. Most multi-user databases support the command.
+The function ''affected_rows()'' returns the number of rows affected (add/change/delete) by the last SQL statement executed, or false if the database does not support the function or the statement is not an update. See the driver documentation for support. Most multi-user databases support the command. Because the method returns ''0'' for zero results and ''false'' for an unsupported statement, it is recommended to use ''==='' if testing for zero or false.
+<WRAP tip>
+Because the connection only supports a single global instance of this variable, it is important to **retrieve the value of this method before executing another SQL statement** (of any type).
+</WRAP>
 ===== Usage =====
 <code php>
@@ Line 12: / Line 17: @@
  * connection assumed
  */
-$db->Execute('DELETE FROM act WHERE actno = 20');
+$db->execute('DELETE FROM act WHERE actno = 20');
 print $db->affected_rows();
@@ Line 19: / Line 24: @@
  */
-$db->Execute('SELECT FROM act');
+$db->execute('SELECT FROM act');
 print $db->affected_rows();
 /*
@@ Line 25: / Line 30: @@
  */
 </code>