ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:mysql_tutorial

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:userguide:mysql_tutorial [2016/02/27 18:43] – [Inserts and Updates] mnewnhamv5:userguide:mysql_tutorial [2016/02/27 18:44] – [Select Limit and Top Support] mnewnham
Line 228: Line 228:
 ==== Select Limit and Top Support ==== ==== Select Limit and Top Support ====
  
-ADOdb has a function called ''[[v5:reference:selectlimit|$connection->SelectLimit($sql,$nrows,$offset)]]'' that allows you to retrieve a subset of the recordset. This will take advantage of native ''SELECT TOP'' on Microsoft products and ''SELECT ... LIMIT'' with PostgreSQL and MySQL, and emulated if the database does not support it.+ADOdb has a function called ''[[v5:reference:connection:selectlimit|$connection->SelectLimit($sql,$nrows,$offset)]]'' that allows you to retrieve a subset of the recordset. This will take advantage of native ''SELECT TOP'' on Microsoft products and ''SELECT ... LIMIT'' with PostgreSQL and MySQL, and emulated if the database does not support it.
  
 ==== Caching Support ==== ==== Caching Support ====
v5/userguide/mysql_tutorial.txt · Last modified: 2018/06/27 16:09 by dregad