Differences

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

--- reference:selectlimit [2015/07/21 19:29] – mnewnham
+++ v5:reference:connection:selectlimit [2018/07/02 14:31] – prefer functions start lowercase (#430) peterdd
@@ Line 17: / Line 17: @@
 The function executes a statement, and returns a handle to a recordset or false if the statement execution fails.
-The presentation of the returned data can be modified by the variables [[reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[reference:setfetchmode|setFetchMode()]].
+The presentation of the returned data can be modified by the variables:
+  * [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]
+  * [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]]
+  * The function [[v5:reference:connection:setfetchmode|setFetchMode()]].
-For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[reference:execute|execute()]].
+For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:connection:execute|execute()]].
 ===== $rowsToReturn =====
-''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned my be less. If the value is -1, then all rows starting at the requested offset are returned. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[reference:execute|execute()]].
+''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned my be less. If the value is -1, then all rows starting at the requested offset are returned. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[v5:reference:connection:execute|execute()]].
 ===== $startOffset =====
-''$startOffset'' indicates the n<sup>th</sup> row at which to start the request. Row numbers start at 1.  If the row number is beyond End-Of-File then an empty recordset will be returned.
+''$startOffset'' indicates the n<sup>th</sup> row at which to start the request. Row numbers start at 0.  If the row number is beyond End-Of-File then an empty recordset will be returned.
@@ Line 35: / Line 38: @@
 */
 $SQL = "SELECT * FROM act";
-$result = $db->SelectLimit($SQL,2,3);
+$result = $db->selectLimit($SQL,2,3);
-while ($r = $result->FetchRow())
+while ($r = $result->fetchRow())
     print_r($r);
 /*
- * Returns 2 rows starting at offset 3
+ * Returns 2 rows starting at offset 3 (4th record starting at 0)