Differences

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

--- reference:recordcount [2015/07/25 06:26] – mnewnham
+++ v5:reference:connection:recordcount [2018/05/03 14:39] (current) – [recordCount] method, not function dregad
@@ Line 2: / Line 2: @@
 <WRAP right box>
 == See Also ==
-[[database:feature_comparison|Compatibility Matrix]]
+[[v5:database:feature_comparison|Feature Comparison Matrix]]
 == Syntax ==
    int recordCount()
 </WRAP>
-The function ''recordCount()'' return the number of records returned by the last select statement, or -1 if the database driver does not support the operation.
+The ''recordCount()'' method returns the number of records retrieved by the last select statement, or -1 if the database driver does not support the operation.
-</WRAP>
+If [[v5:reference:adodb_countrecs|$ADODB_COUNTRECS]] is set to true before a query is executed, then the number of records will be retrieved, even if the function has to be emulated by issuing a ''COUNT *'' on the query. This can result in slow responses.
+----------------------------
+===== Usage =====
+<code php>
+/*
+ * Existing database connection assumed
+ */
+$result = $db->Execute('SELECT * FROM act');
+$recordCount = $result->recordCount();
+</code>