ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:selectlimit

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
v5:reference:connection:selectlimit [2016/01/19 21:18] – ↷ Links adapted because of a move operation 66.249.64.103v5: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 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 [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[v5:reference:connection: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 [[v5:reference:connection:execute|execute()]]. For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:connection:execute|execute()]].
Line 35: Line 38:
 */ */
 $SQL = "SELECT * FROM act"; $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);     print_r($r);
  
v5/reference/connection/selectlimit.txt · Last modified: 2023/07/25 12:55 by dregad