Differences

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

--- reference:affected_rows [2015/07/24 19:10] – created mnewnham
+++ v5:reference:connection:affected_rows [2018/06/11 10:17] – [Usage] function names starting with lowercase (#426) dregad
@@ 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 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 12: / Line 14: @@
  * 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 21: @@
  */
-$db->Execute('SELECT FROM act');
+$db->execute('SELECT FROM act');
 print $db->affected_rows();
 /*