Differences

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

--- reference:po_recordcount [2015/12/04 16:08] – mnewnham
+++ v5:reference:po_recordcount [2016/01/13 02:31] – ↷ Page moved from reference:po_recordcount to v5:reference:po_recordcount mnewnham
@@ Line 1: / Line 1: @@
+====== po_recordCount =====
+<WRAP right box>
+== See Also ==
+[[v5:database:feature_comparison|Feature Comparison Matrix]]\\
+[[reference:ADODB_COUNTRECS]]\\
+== Syntax ==
+   int po_recordCount()
+</WRAP>
+The function ''po_recordCount()'' return the number of records returned by the last select statement.
+This portable function executes a **SELECT COUNT** statement based on the last SQL statement to determine the number of records if the database does not natively support row counting in a select statement.
+There may be a substantial overhead to using this function on large recordsets.
+----------------------------
+===== Usage =====
+<code php>
+/*
+ * Access database connection assumed
+ */
+$result = $db->Execute('SELECT * FROM products');
+$recordCount = $db->po_recordCount();
+</code>