note 105277 added to pdostatement.fetch

Someone's already pointed out that PDO::CURSOR_SCROLL isn't supported by the SQLite driver. It's also worth noting that it's not supported by the MySQL driver either. In fact, if you try to use scrollable cursors with a MySQL statement, the PDO::FETCH_ORI_ABS parameter and the offset given to fetch() will be silently ignored. fetch() will behave as normal, returning rows in the order in which they came out of the database. It's actually pretty confusing behaviour at first. Definitely worth documenting even if only as a user-added note on this page. ---- Server IP: 69.147.83.197 Probable Submitter: 2.220.90.122 ---- Manual Page -- http://www.php.net/manual/en/pdostatement.fetch.php Edit -- https://master.php.net/note/edit/105277 Del: integrated -- https://master.php.net/note/delete/105277/integrated Del: useless -- https://master.php.net/note/delete/105277/useless Del: bad code -- https://master.php.net/note/delete/105277/bad+code Del: spam -- https://master.php.net/note/delete/105277/spam Del: non-english -- https://master.php.net/note/delete/105277/non-english Del: in docs -- https://master.php.net/note/delete/105277/in+docs Del: other reasons-- https://master.php.net/note/delete/105277 Reject -- https://master.php.net/note/reject/105277 Search -- https://master.php.net/manage/user-notes.php