#37839 [NEW]: Limit of returned rows

From: rael at grad dot icmc dot usp dot br Operating system: Any PHP version: 5.1.4 PHP Bug Type: Feature/Change Request Bug description: Limit of returned rows Description: ------------ A PDO method for limit the number of rows returned from a query, independent of the used DBMS. This feature is available in DBMS abstraction packages, like ADODB (and in Java JDBC too). Something like this: function setLimit($limit, $offset); Reproduce code: --------------- $con = new PDO('mysql:host=localhost;dbname=test', $user, $pass); $stmt = $con->prepare("SELECT * FROM table"); $stmt->setLimit(10, 2); Expected result: ---------------- 10 tableresults starting from position 2 Actual result: -------------- Function not exists yet. -- Edit bug report at http://bugs.php.net/?id=37839&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37839&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=37839&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37839&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37839&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37839&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37839&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=37839&r=needscript Try newer version: http://bugs.php.net/fix.php?id=37839&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37839&r=support Expected behavior: http://bugs.php.net/fix.php?id=37839&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37839&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37839&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37839&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37839&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37839&r=dst IIS Stability: http://bugs.php.net/fix.php?id=37839&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37839&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37839&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37839&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=37839&r=mysqlcfg