Differences

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

--- v5:reference:connection:affected_rows [2017/04/21 11:50] – external edit 127.0.0.1
+++ v5:reference:connection:affected_rows [2022/04/03 12:48] – Add tip wrap dregad
@@ Line 8: / Line 8: @@
 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).**
+<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 14: / 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 21: / Line 24: @@
  */
-$db->Execute('SELECT FROM act');
+$db->execute('SELECT FROM act');
 print $db->affected_rows();
 /*