Differences

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

--- v5:reference:connection:affected_rows [2018/06/11 10:17] – [Usage] function names starting with lowercase (#426) dregad
+++ 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>
-**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).**
 ===== Usage =====
 <code php>
@@ Line 27: / Line 30: @@
  */
 </code>